pgsql: Add calcluation of bitmap storage capacity.

From: momjian(at)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add calcluation of bitmap storage capacity.
Date: 2005-12-02 04:28:27
Message-ID: 20051202042827.829DC9DD71E@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Add calcluation of bitmap storage capacity.

< be cleared when a heap tuple is expired. Another idea is to maintain
< a bitmap of heap pages where all rows are visible to all backends,
< and allow index lookups to reference that bitmap to avoid heap
< lookups, perhaps the same bitmap we might add someday to determine
< which heap pages need vacuuming.
> be cleared when a heap tuple is expired.
>
> Another idea is to maintain a bitmap of heap pages where all rows
> are visible to all backends, and allow index lookups to reference
> that bitmap to avoid heap lookups, perhaps the same bitmap we might
> add someday to determine which heap pages need vacuuming. Frequently
> accessed bitmaps would have to be stored in shared memory. One 8k
> page of bitmaps could track 512MB of heap pages.

Modified Files:
--------------
pgsql/doc:
TODO (r1.1709 -> r1.1710)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1709&r2=1.1710)
pgsql/doc/src/FAQ:
TODO.html (r1.216 -> r1.217)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html.diff?r1=1.216&r2=1.217)

Browse pgsql-committers by date

  From Date Subject
Next Message User Dpage 2005-12-02 11:00:44 psqlodbc - psqlodbc: - skip QR_fetch_tuples when backend returns
Previous Message Bruce Momjian 2005-12-02 02:49:21 Re: [COMMITTERS] pgsql: Add comments about why errno is set