Re: ECPG FETCH readahead - Mailing list pgsql-hackers

From Noah Misch
Subject Re: ECPG FETCH readahead
Date
Msg-id 20120409021519.GD11987@tornado.leadboat.com
Whole thread Raw
In response to Re: ECPG FETCH readahead  (Michael Meskes <meskes@postgresql.org>)
List pgsql-hackers
On Sun, Apr 08, 2012 at 04:25:01PM +0200, Michael Meskes wrote:
> On Sat, Apr 07, 2012 at 11:50:42AM -0400, Noah Misch wrote:
> > I do call your attention to a question I raised in my second review: if a
> > program contains "DECLARE foo READAHEAD 5 CURSOR FOR ..." and the user runs
> > the program with ECPGFETCHSZ=10 in the environment, should that cursor use a
> > readahead window of 5 or of 10?  Original commentary:
> > http://archives.postgresql.org/message-id/20120329004323.GA17329@tornado.leadboat.com
> 
> I'd say it should be 5. I don't like an environment variable overwriting a
> hard-coded setting. I think this is what you, Noah, thought, too, right?

Yes.


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: bug in fast-path locking
Next
From: "Etsuro Fujita"
Date:
Subject: Re: WIP: Collecting statistics on CSV file data