| From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "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 18:11:02 |
| Message-ID: | 87wsvcj3k9.fsf@oxford.xeocode.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> 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 ...
Incidentally, there was a previous discussion about this a while back.
I can't seem to find it in the archives though.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2007-08-30 18:20:18 | Re: PostgreSQL.Org (was: PostgreSQL Conference Fall 2007) |
| Previous Message | Tom Lane | 2007-08-30 18:07:57 | Re: Out of Memory - 8.2.4 |