Re: Index-only scan performance regression

Robert Haas <robertmhaas@gmail.com>

From: Robert Haas <robertmhaas@gmail.com>
To: Dean Rasheed <dean.a.rasheed@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2012-01-31T19:49:52Z
Lists: pgsql-hackers
On Tue, Jan 31, 2012 at 2:15 PM, Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
> In the case when we're asked to clear a bit, it would first try to pin
> the relevant page, which would go through vm_readbuf() with extend set
> to true. Then vm_extend() would notice that the visibility map had
> already been extended, and it would read in the new page with the set
> bit. So this case would continue to work, wouldn't it?

Ah, maybe.  I haven't tried to code it up.  Do you want to take a crack at it?

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