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

From Robert Haas
Subject Re: the big picture for index-only scans
Date
Msg-id CA+TgmobrxPoCwZvj1JQAGzEVOYp8omh_jwYdiEZfy7NoLHH+nQ@mail.gmail.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 Sat, Aug 20, 2011 at 4:57 AM, Gokulakannan Somasundaram
<gokul007@gmail.com> wrote:
> by your argument, if WALInserLock is held for 't' seconds, you should
> definitely be holding visibility map lock for more than time frame 't'.

Nope, that's not how it works.  Perhaps you should read the code.
See, e.g., heap_update().

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: the big picture for index-only scans
Next
From: Robert Haas
Date:
Subject: Re: the big picture for index-only scans