Re: the big picture for index-only scans - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: the big picture for index-only scans
Date
Msg-id 4E4EAA8C.4060408@enterprisedb.com
Whole thread Raw
In response to Re: the big picture for index-only scans  (Gokulakannan Somasundaram <gokul007@gmail.com>)
Responses Re: the big picture for index-only scans
List pgsql-hackers
On 19.08.2011 21:06, Gokulakannan Somasundaram wrote:
> If you are following the same design that Heikki put forward, then there is
> a problem with it in maintaining the bits in page and the bits in visibility
> map in sync, which we have already discussed.

Are you referring to this: 
http://archives.postgresql.org/pgsql-hackers/2010-02/msg02097.php ? I 
believe Robert's changes to make the visibility map crash-safe covers 
that. Clearing the bit in the visibility map now happens within the same 
critical section as clearing the flag on the heap page and writing th 
WAL record.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: "Sergey E. Koposov"
Date:
Subject: two index bitmap scan of a big table & hash_seq_search
Next
From: Gokulakannan Somasundaram
Date:
Subject: Re: the big picture for index-only scans