Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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: scan_recycle_buffers.v1.patch
Description: text/x-patch (12.7 KB)

Responses

pgsql-hackers by date

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

pgsql-patches by date

Next:From: Heikki LinnakangasDate: 2007-03-09 20:08:55
Subject: Re: scan_recycle_buffers
Previous:From: Gregory StarkDate: 2007-03-09 17:37:55
Subject: non-recursive WITH clause support

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group