scan_recycle_buffers - Mailing list pgsql-patches

From Simon Riggs
Subject scan_recycle_buffers
Date
Msg-id 1173468253.3641.335.camel@silverbirch.site
Whole thread Raw
Responses Re: scan_recycle_buffers  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-patches
Patch to implement buffer cache recycling for scans, as being discussed
on pgsql-hackers.

Applies cleanly to cvstip, passes make installcheck when used by default
for all SeqScans. Tested with scan_recycle_buffers = 1,4,8,16

Should be regarded as WIP. Presumably there are some failure conditions
that require the buffer to be reset; these have not yet been considered.

No docs.

SET scan_recyle_buffers = N
default = 0

8 <= N <= 64 would yield benefits according to earlier results

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com


Attachment

pgsql-patches by date:

Previous
From: Gregory Stark
Date:
Subject: non-recursive WITH clause support
Next
From: Heikki Linnakangas
Date:
Subject: Re: scan_recycle_buffers