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 [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend