On Fri, 2008-06-06 at 20:19 -0400, Tom Lane wrote: > Robert Treat <[EMAIL PROTECTED]> writes:
> Actually, the reason it's still 10 is that the effort expended to get it > changed has been *ZERO*. I keep asking for someone to make some > measurements, do some benchmarking, anything to make a plausible case > for a specific higher value as being a reasonable place to set it. > The silence has been deafening. Not surprising really. It is a simple adjustment to make and it also is easy to spot when its a problem. However it is not trivial to test for (in terms of time and effort). I know 10 is wrong and so do you. If you don't I am curious why I see so many posts from you saying, "Your estimates are off, what is your default_statistics_target?" with yet even more responses saying, "Uhh 10." Sincerely, Joshua D. Drake -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers