old_snapshot_threshold's interaction with hash index - Mailing list pgsql-hackers

From Amit Kapila
Subject old_snapshot_threshold's interaction with hash index
Date
Msg-id CAA4eK1+Wy+N4eE5zPm765h68LrkWc3Biu_8rzzi+OYX4j+iHRw@mail.gmail.com
Whole thread Raw
Responses Re: old_snapshot_threshold's interaction with hash index  (Amit Kapila <amit.kapila16@gmail.com>)
List 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 by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Add jsonb_compact(...) for whitespace-free jsonb to text
Next
From: Amit Kapila
Date:
Subject: Re: old_snapshot_threshold's interaction with hash index