"Greg Stark" <st...@enterprisedb.com> writes: > On Fri, Dec 12, 2008 at 2:35 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: >> But having said that, I have wondered whether we should consider >> allowing the sample to grow to fill maintenance_work_mem
> Hm, so I wonder what this does to the time analyze takes. I think it > would be the only thing where raising maintenance_work_mem would > actually increase the amount of time an operation takes. Generally > people raise it to speed up index builds and vacuums etc. Yeah --- we might need to make it a separate GUC knob instead of tying it directly to maintenance_work_mem. But still, is *any* fixed-size sample really going to help much for large tables? 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