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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to