Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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)

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group