Re: Index-only scan performance regression - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Index-only scan performance regression
Date
Msg-id CA+Tgmobvyn28tNzEWfToAFavWU17=dR+mtoSgkspFmfWMBvJow@mail.gmail.com
Whole thread Raw
In response to Re: Index-only scan performance regression  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: Index-only scan performance regression  (Dean Rasheed <dean.a.rasheed@gmail.com>)
List 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


pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: JSON for PG 9.2
Next
From: Martijn van Oosterhout
Date:
Subject: Re: [GENERAL] pg_dump -s dumps data?!