On Thu, Aug 4, 2016 at 01:16:20AM +0100, Simon Riggs wrote:
> > Would you only add a LITE index entry when there isn't an
> > existing index entry for the same values and heap page? That seems
> > quite complicated.
>
> The insertion algorithm is described. Doesn't seem complicated to me.
Ah, I see it now:
As UPDATEs occur we request inserts into the index. If a lossy indexpointer already exists that covers the new
linepointerthen we skipthe index insert, optimizing writes to the index.
I thought you meant "already exists" just means it matches the existing
range. I was unclear that was the entire page.
-- Bruce Momjian <bruce@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 +