Thread: Re: Planner problems in 8.2.4 and 8.2.5 (was: Possible planner bug/regression introduced in 8.2.5)

Please Unsubscribe me !! from this list ..please ...

Please delete me from this list
=20



----- Original Message ----
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Greg Sabino Mullane <greg@turnstep.com>
Cc: pgsql-bugs@postgresql.org
Sent: Wednesday, 14 November, 2007 10:26:35 AM
Subject: Re: [BUGS] Planner problems in 8.2.4 and 8.2.5 (was: Possible plan=
ner bug/regression introduced in 8.2.5)

"Greg Sabino Mullane" <greg@turnstep.com> writes:
> Can we switch the default_statistics_target to a default of 100? Is=20
> there any reason not to do so at this point?

Other than a 10x increase in the cost of ANALYZE, and in the cost of
histogram-based operations in the planner?

It's been clear for quite awhile that a stats target of 10 is often
too low, but no one has done the legwork to establish what a more
reasonable tradeoff point would be.  I'm not for increasing the overhead
by a factor of 10 ... or even a factor of 2 ... without some real
evidence about the implications.

I'd be inclined to approach it by first trying to establish what's a
sane default for operations unrelated to LIKE estimation.  If that comes
out as 50 or more, I'd just lower the LIKE threshold to whatever it
comes out at.  The 100 number was really just a guess in the first
place.

            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate


      5, 50, 500, 5000 - Store N number of mails in your inbox. Go to http:=
//help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html=