Re: Have vacuum emit a warning when it runs out of maintenance_work_mem - Mailing list pgsql-patches

From Heikki Linnakangas
Subject Re: Have vacuum emit a warning when it runs out of maintenance_work_mem
Date
Msg-id 464892D2.3050705@enterprisedb.com
Whole thread Raw
In response to Re: Have vacuum emit a warning when it runs out of maintenance_work_mem  ("Jim C. Nasby" <decibel@decibel.org>)
Responses Re: Have vacuum emit a warning when it runs out of maintenance_work_mem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Jim C. Nasby wrote:
> Did someone come up with a bitmap compression scheme for on-disk bitmap
> indexes that would help out here? Some form of compression could make a
> big difference in mostly-dead pages.

Yes, there's a pretty nice compression scheme there, but the requirement
for random access makes it a bit hard to use in this case.

> If nothing else, it would likely be
> worth special-casing an entire page being dead, which is a common case
> for queue tables. That could be done by making an entry in the page
> number array with a special offset value.

That won't work, because someone might add live tuples to the page after
the 1st vacuum pass. You could only invoke that special case when
there's no room on the page for new tuples, but that's a hack and not as
common.

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

pgsql-patches by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Concurrent psql patch
Next
From: Tom Lane
Date:
Subject: Re: Have vacuum emit a warning when it runs out of maintenance_work_mem