| From: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>, <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: scan_recycle_buffers |
| Date: | 2007-03-10 08:48:31 |
| Message-ID: | 1173516512.3641.398.camel@silverbirch.site |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
On Sat, 2007-03-10 at 07:59 +0000, Simon Riggs wrote:
> On Fri, 2007-03-09 at 18:05 -0500, Tom Lane wrote:
> > "Simon Riggs" <simon(at)2ndquadrant(dot)com> writes:
> > > On Fri, 2007-03-09 at 16:45 -0500, Tom Lane wrote:
> > >> We do that anyway; but certainly Simon's patch ought not be injecting
> > >> an additional one.
> >
> > > It should be possible to pass that down from the planner to the
> > > executor, in certain cases.
> >
> > Huh? See HeapScanDesc->rs_nblocks.
>
> Many thanks.
New patch enclosed, implementation as you've requested.
Not ready to apply yet, but good for testing.
COPY command now also uses this hint, to allow test results and
discussion. Others could also, perhaps needing different values.
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
| Attachment | Content-Type | Size |
|---|---|---|
| scan_recycle_buffers.v2.patch | text/x-patch | 13.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Stark | 2007-03-10 09:42:54 | Re: [PATCHES] scan_recycle_buffers |
| Previous Message | Heikki Linnakangas | 2007-03-10 08:29:12 | Re: My honours project - databases using dynamically attached entity-properties |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Stark | 2007-03-10 09:42:54 | Re: [PATCHES] scan_recycle_buffers |
| Previous Message | Simon Riggs | 2007-03-10 07:59:55 | Re: scan_recycle_buffers |