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

Re: scan_recycle_buffers

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: scan_recycle_buffers
Date: 2007-04-02 23:10:58
Message-ID: 200704022310.l32NAwh17732@momjian.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Where is the final version of this patch?  What patches are stuck in the
patch moderator queue?

---------------------------------------------------------------------------

Simon Riggs wrote:
> 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, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-hackers by date

Next:From: Mark DilgerDate: 2007-04-02 23:11:57
Subject: Re: Bug in UTF8-Validation Code?
Previous:From: Bruce MomjianDate: 2007-04-02 23:09:12
Subject: Re: Interaction of PITR backups and Bulkoperationsavoiding WAL

pgsql-patches by date

Next:From: Bruce MomjianDate: 2007-04-02 23:17:11
Subject: Re: HOT WIP Patch - version 6.3
Previous:From: Bruce MomjianDate: 2007-04-02 23:06:11
Subject: Re: CREATE TABLE LIKE INCLUDING INDEXES support

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