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 |
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) |
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 |