Josh Berkus <[EMAIL PROTECTED]> writes: > Gregory Stark wrote: >> Josh Berkus <[EMAIL PROTECTED]> writes: >>> DW: >>> default_statistics_target = 400 >>> Mixed: >>> default_statistics_target = 100 >> >> You, my friend, are certifiably insane.
> Hmmm? Why? I've used those settings in the field, fairly frequently. Even though we all agree default_statistics_target = 10 is too low, proposing a 40X increase in the default value requires more evidence than this. In particular, the prospect of a 1600-fold increase in the typical cost of eqjoinsel() is a mite scary. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers