old_snapshot_threshold's interaction with hash index

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема old_snapshot_threshold's interaction with hash index
Дата
Msg-id CAA4eK1+Wy+N4eE5zPm765h68LrkWc3Biu_8rzzi+OYX4j+iHRw@mail.gmail.com
обсуждение исходный текст
Ответы Re: old_snapshot_threshold's interaction with hash index  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
Currently we do the test for old snapshot (TestForOldSnapshot) for hash indexes while scanning them.  Does this test makes any sense for hash indexes considering LSN on hash index will always be zero (as hash indexes are not WAL-logged)?  It seems to me that PageLSN check in TestForOldSnapshot() will always return false which means that the error "snapshot too old" won't be generated for hash indexes.

Am I missing something here, if not, then I think we need a way to prohibit pruning for hash indexes based on old_snapshot_threshold?  


With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Add jsonb_compact(...) for whitespace-free jsonb to text
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: old_snapshot_threshold's interaction with hash index