Re: Killing dead index tuples before they get vacuumed

From: "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Killing dead index tuples before they get vacuumed
Date: 2002-05-22 10:28:59
Message-ID: 46C15C39FEB2C44BA555E356FBCD6FA4961DD2@m0114.s-mxs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 4. How exactly should a killed index tuple be marked on-disk? While there
> is one free bit available in IndexTupleData.t_info, I would prefer to use
> that bit to expand the index tuple size field to 14 bits instead of 13.
> (This would allow btree index entries to be up to 10K when BLCKSZ is 32K,
> rather than being hard-limited to 8K.)

While I agree that it might be handy to save this bit for future use,
I do not see any value in increasing the max key length from 8k,
especially when the new limit is then 10k. The limit is already 32 *
the max key size of some other db's, and even those 256 bytes are usually
sufficient.

Andreas

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Shra 2002-05-22 13:04:03
Previous Message Michael Meskes 2002-05-22 09:54:33 Re: interfaces/ecpg/preproc reduce/reduce conflicts