"Greg Stark" <[email protected]> writes:
> On Fri, Dec 12, 2008 at 2:35 PM, Tom Lane <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
