Re: Performance Improvement for Unique Indexes

Поиск
Список
Период
Сортировка
От Gokulakannan Somasundaram
Тема Re: Performance Improvement for Unique Indexes
Дата
Msg-id 9362e74e1003240834h531cefd8m52dd70b24877f359@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance Improvement for Unique Indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers

it seems fairly unlikely to me that this would be useful enough to
justify using up a precious hint bit.  The applicability of the hint
is very short-term --- as soon as the tuple is dead to all transactions,
it can be marked with the existing LP_DEAD hint bit.  And if it's only
useful for uniqueness checks, as seems to be the case, that's another
big restriction on the value.

Right. It is of little value.

Gokul.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: WIP: preloading of ispell dictionary
Следующее
От: Tom Lane
Дата:
Сообщение: last_statrequest is in the future