Re: Out of Memory - 8.2.4

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Marko Kreen <markokr(at)gmail(dot)com>, Jeff Amiel <becauseimjeff(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Out of Memory - 8.2.4
Date: 2007-08-30 16:20:55
Message-ID: 2311.1188490855@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alvaro Herrera <alvherre(at)commandprompt(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Denis Gasparin 2007-08-30 16:21:02 Re: Autovacuum not vacuuming pg_largeobject
Previous Message Dan Langille 2007-08-30 16:19:03 Re: PostgreSQL Conference Fall 2007