Re: An idle thought - Mailing list pgsql-hackers

From Gokulakannan Somasundaram
Subject Re: An idle thought
Date
Msg-id 9362e74e1003182319t10d46c75x8cdac38ca2195e94@mail.gmail.com
Whole thread Raw
In response to Re: An idle thought  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-hackers
Surely the VM is already update-friendly. If you update a tuple in a
page with the visibility bit set, the bit must be unset or you will get
wrong results.

 
I was referring in the context of index only scans to skip visibility checks. I doubt, whether the visibility map feature to skip visibility checks at the heap can be created without any extra cost to updates/inserts. When a data is compressed then there is more contention for the same block and hence would likely affect DMLs. I hope that's what Tom was also referring to, but not in the visibility map context.

Gokul.

pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Getting to beta1
Next
From: KaiGai Kohei
Date:
Subject: [BUG] SECURITY DEFINER on call handler makes daemon crash