scan_recycle_buffers

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: <pgsql-patches(at)postgresql(dot)org>
Subject: scan_recycle_buffers
Date: 2007-03-09 19:24:13
Message-ID: 1173468253.3641.335.camel@silverbirch.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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 Content-Type Size
scan_recycle_buffers.v1.patch text/x-patch 12.7 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2007-03-09 19:27:55 Re: Bug: Buffer cache is not scan resistant
Previous Message Gaetano Mendola 2007-03-09 18:37:33 Re: Calculated view fields (8.1 != 8.2)

Browse pgsql-patches by date

  From Date Subject
Next Message Heikki Linnakangas 2007-03-09 20:08:55 Re: scan_recycle_buffers
Previous Message Gregory Stark 2007-03-09 17:37:55 non-recursive WITH clause support