Re: Bug: Buffer cache is not scan resistant - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: Bug: Buffer cache is not scan resistant
Date
Msg-id 4E324E75-2AF9-4F2F-A9A9-88248AEF205A@decibel.org
Whole thread Raw
In response to Re: Bug: Buffer cache is not scan resistant  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: Bug: Buffer cache is not scan resistant
List pgsql-hackers
On Mar 6, 2007, at 10:56 AM, Jeff Davis wrote:
>> We also don't need an exact count, either. Perhaps there's some way
>> we could keep a counter or something...
>
> Exact count of what? The pages already in cache?

Yes. The idea being if you see there's 10k pages in cache, you can  
likely start 9k pages behind the current scan point and still pick  
everything up.

But this is nowhere near as useful as the bitmap idea, so I'd only  
look at it if it's impossible to make the bitmaps work. And like  
others have said, that should wait until there's at least a first- 
generation patch that's going to make it into 8.3.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)




pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Bug: Buffer cache is not scan resistant
Next
From: ITAGAKI Takahiro
Date:
Subject: Re: Aggressive freezing in lazy-vacuum