Simon Riggs wrote:
> Patch to implement buffer cache recycling for scans, as being discussed
> on pgsql-hackers.
A few questions come to mind:
How does it behave with Jeff's synchronized seq scans patch?
I wonder if calling RelationGetNumberOfBlocks on every seq scan becomes
a performance issue for tiny tables with for example just 1 page. It
performs an lseek, which isn't free.
What happens if multiple backends choose overlapping sets of buffers to
recycle?
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com