Re: Search from newer tuples first, vs older tuples first?

Tom Lane wrote:
> Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> writes:
> > OK I'm starting to get it :). Will the index behaviour be changed soon?
>
> When someone steps up and does it. I've learned not to predict
> schedules for this project.

It is not that hard to implement, just messy. When the index returns a
heap row and the heap row is viewed for visibility, if _no_one_ can see
the row, the index can be marked as expired. It could be a single bit
in the index tuple, and doesn't need to be flushed to disk, though the
index page has to be marked as dirty. However, we are going to need to
flush a pre-change image to WAL so it may as well be handled as a normal
index page change.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026