Re: Out of Memory - 8.2.4 - Mailing list pgsql-general

From Tom Lane
Subject Re: Out of Memory - 8.2.4
Date
Msg-id 2311.1188490855@sss.pgh.pa.us
Whole thread Raw
In response to Re: Out of Memory - 8.2.4  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Out of Memory - 8.2.4  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-general
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Maybe we could load it in a more compact form after the heap cleanup
> pass, instead of a plain TID list.

Hmm ... a non-lossy bitmap would be an interesting alternative.
I think I went with bsearch mainly because I knew I could generate
the TID list already sorted.  Somebody should try to measure the
probe time of the tidbitmap code against bsearch ...

            regards, tom lane

pgsql-general by date:

Previous
From: Denis Gasparin
Date:
Subject: Re: Autovacuum not vacuuming pg_largeobject
Next
From: Alvaro Herrera
Date:
Subject: Re: Out of Memory - 8.2.4