Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Block B-Tree concept
- From: Bruce Momjian <bruce(at)momjian(dot)us>
- To: Teodor Sigaev <teodor(at)sigaev(dot)ru>
- Cc: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
- Subject: Re: Block B-Tree concept
- Date: Tue, 26 Sep 2006 08:32:59 -0400 (EDT)
- Message-id: <200609261232(dot)k8QCWxN07210(at)momjian(dot)us>
Teodor Sigaev wrote: > > 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... I think block indexes would only be for btrees. -- Bruce Momjian bruce(at)momjian(dot)us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
- References:
- Re: Block B-Tree concept
- From: Teodor Sigaev
- Re: Block B-Tree concept
- Prev by Date: Re: Release Notes: Major Changes in 8.2
- Next by Date: Re: Block B-Tree concept
- Previous by thread: Re: Block B-Tree concept
- Next by thread: Re: Block B-Tree concept
- Indexes: