On Thu, Aug 4, 2016 at 06:18:47PM +0100, Simon Riggs wrote: > > Have you considered what it'd take to allow index pointers to allow to > > point to "intermediate" root tuples? I.e. have some indexes point into > > the middle of an update-chain, whereas others still point to the > > beginning? There's certainly some complications involved with that, but > > it'd also have the advantage in reducing the amount of rechecking that > > needs to be done. > > "Intermediate root tuples" was my first attempt at this and it didn't > work. I'll dig up the details, some problem in VACUUM, IIRC.
I think the problem is that HOT chain pruning becomes almost impossible except via VACUUM. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
