Postgres Pro
Downloads
Home   >   mailing lists

Re: Block B-Tree concept - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: Block B-Tree concept
Date
Msg-id 45191D2A.7010401@sigaev.ru
Whole thread Raw
In response to Re: Block B-Tree concept  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Block B-Tree concept
Re: Block B-Tree concept
List pgsql-hackers
Tree view 
> Right now, if an index entry points to a dead tuple, we set a bit in 
> the index so future lookups do not access the heap.  We could set a bit 
> for block index entries that point to a page that has no live rows, and
> have vacuum remove the index entry later.

GIN don't support this feature...
-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Questions about guc units
Next
From: Bruce Momjian
Date:
Subject: Re: Release Notes: Major Changes in 8.2