Jim C. Nasby wrote:
On Sat, May 12, 2007 at 07:57:44PM +0100, Heikki Linnakangas wrote:
Or we could switch to a more compact representation of the dead tuples, and not need such a big maintenance_work_mem in the first place.

Sure, but even with a more compact representation you can still run out
of maintenance_work_mem... unless we allow this to spill to disk. At
first guess that sounds insane, but if you've got a large enough set of
indexes it *might* actually be faster.

It would only make sense if the table is clustered on an index, so that you'd in practice only need to keep part of the array in memory at a time. It's pretty narrow use case, not worth spending time on I think.

Either way, as long as maintenance_work_mem is an issue I think we need
a way to warn users.

I agree.

  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to