Re: Killing dead index tuples before they get vacuumed

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB SD
Тема Re: Killing dead index tuples before they get vacuumed
Дата
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA4961DD2@m0114.s-mxs.net
обсуждение исходный текст
Ответ на Killing dead index tuples before they get vacuumed  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Killing dead index tuples before they get vacuumed
Список 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Meskes
Дата:
Сообщение: Re: interfaces/ecpg/preproc reduce/reduce conflicts
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: Killing dead index tuples before they get vacuumed