Re: scan_recycle_buffers - Mailing list pgsql-patches

From Heikki Linnakangas
Subject Re: scan_recycle_buffers
Date
Msg-id 45F1BED7.40807@enterprisedb.com
Whole thread Raw
In response to scan_recycle_buffers  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: scan_recycle_buffers
Re: scan_recycle_buffers
Re: scan_recycle_buffers
List pgsql-patches
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

pgsql-patches by date:

Previous
From: "Simon Riggs"
Date:
Subject: scan_recycle_buffers
Next
From: "Simon Riggs"
Date:
Subject: Re: scan_recycle_buffers