From: Michael Meskes <meskes@postgresql.org>
To: Boszormenyi Zoltan <zb@cybertec.at>
Cc: Noah Misch <noah@leadboat.com>
Cc: Michael Meskes <meskes@postgresql.org>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: PG Hackers <pgsql-hackers@postgresql.org>
Cc: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Cc: Bruce Momjian <bruce@momjian.us>
Subject: Re: ECPG FETCH readahead
Date: Sun, 8 Apr 2012 19:38:59 +0200
Message-ID: <20120408173859.GA4915@feivel.credativ.lan> (raw)
In-Reply-To: <4F81BE55.1010904@cybertec.at>
References: <CA+TgmoaBGLpW5V3nFES-McLbZyY_9nUvpnFLjT7zAYuVPu809A@mail.gmail.com>
<4F6D9893.3030300@cybertec.at>
<20120329004323.GA17329@tornado.leadboat.com>
<4F74409C.3050904@cybertec.at>
<20120329170341.GA4142@tornado.leadboat.com>
<4F74E6A7.8040204@cybertec.at>
<20120407112008.GA2286@feivel.credativ.lan>
<20120407155042.GB11987@tornado.leadboat.com>
<20120408142501.GA21513@feivel.credativ.lan>
<4F81BE55.1010904@cybertec.at>
On Sun, Apr 08, 2012 at 06:35:33PM +0200, Boszormenyi Zoltan wrote:
> Do you want me to change this or will you do it? I am on holiday
> and will be back to work on wednesday.
I don't think waiting till later this week is a real problem.
> The possibility to test different readahead window sizes
> without modifying the source and recompiling was useful.
Sure, but you can still do that when not defining a fixed number in the
statement.
> The -R option simply provides a default without ornamenting
> the DECLARE statement.
Could you please incorporate these changes, too, when you're back from vacation?
> >I cannot find a test that tests the environment variable giving the fetch size.
> >Could you please point me to that?
>
> I didn't write such a test. The reason is that while variables are
> exported by make from the Makefile to the binaries run by make
> e.g. CFLAGS et.al. for $(CC), "make check" simply runs pg_regress
> once which uses its own configuration file that doesn't have a
> way to set or unset an environment variable. This could be a useful
> extension to pg_regress though.
How about calling setenv() from the test program itself?
Michael
--
Michael Meskes
Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
Michael at BorussiaFan dot De, Meskes at (Debian|Postgresql) dot Org
Jabber: michael.meskes at googlemail dot com
VfL Borussia! Força Barça! Go SF 49ers! Use Debian GNU/Linux, PostgreSQL
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: meskes@postgresql.org, zb@cybertec.at, noah@leadboat.com, robertmhaas@gmail.com, heikki.linnakangas@enterprisedb.com, bruce@momjian.us
Subject: Re: ECPG FETCH readahead
In-Reply-To: <20120408173859.GA4915@feivel.credativ.lan>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox