Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 886CF159075;
	Mon,  5 Mar 2012 04:25:30 -0400 (AST)
Received: from gauss.credativ.com ([93.94.130.89])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <michael@fam-meskes.de>)
	id 1S4TEX-0003rQ-3P; Mon, 05 Mar 2012 08:25:30 +0000
Received: from feivel (exit.credativ.com [87.139.82.80])
	(using TLSv1 with cipher ADH-AES256-SHA (256/256 bits))
	(No client certificate requested)
	(Authenticated sender: mme@gauss.credativ.com)
	by gauss.credativ.com (Postfix) with ESMTPSA id 56B1C1B41F0;
	Mon,  5 Mar 2012 09:25:14 +0100 (CET)
Received: by feivel (Postfix, from userid 1000)
	id 032709F108; Mon,  5 Mar 2012 09:26:16 +0100 (CET)
Date: Mon, 5 Mar 2012 09:26:15 +0100
From: Michael Meskes <meskes@postgresql.org>
To: Boszormenyi Zoltan <zb@cybertec.at>
Cc: Noah Misch <noah@leadboat.com>, Michael Meskes <meskes@postgresql.org>,
	PG Hackers <pgsql-hackers@postgresql.org>,
	Robert Haas <robertmhaas@gmail.com>,
	Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>,
	Bruce Momjian <bruce@momjian.us>
Subject: Re: ECPG FETCH readahead
Message-ID: <20120305082615.GA28695@feivel.credativ.lan>
Mail-Followup-To: Boszormenyi Zoltan <zb@cybertec.at>,
	Noah Misch <noah@leadboat.com>,
	Michael Meskes <meskes@postgresql.org>,
	PG Hackers <pgsql-hackers@postgresql.org>,
	Robert Haas <robertmhaas@gmail.com>,
	Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>,
	Bruce Momjian <bruce@momjian.us>
References: <4C2308FD.1090300@cybertec.at> <4C231F9E.6000102@enterprisedb.com>
	<20100624121922.GD24137@feivel.credativ.lan>
	<AANLkTinij9ULnS54zKsdAJnhvuj-07-8-T-D=Nwk6f14@mail.gmail.com>
	<4CB6D3C8.3020709@cybertec.at> <4EC41434.7010603@cybertec.at>
	<4EFC36EF.1060308@cybertec.at>
	<20120302164105.GD23100@tornado.leadboat.com>
	<20120304161606.GA4706@feivel.credativ.lan>
	<4F5399AA.5020104@cybertec.at>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <4F5399AA.5020104@cybertec.at>
User-Agent: Mutt/1.5.21 (2010-09-15)
Content-Transfer-Encoding: quoted-printable
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201203/176
X-Sequence-Number: 204058

On Sun, Mar 04, 2012 at 05:34:50PM +0100, Boszormenyi Zoltan wrote:
> The program logic shouldn't change at all. He meant that extra coding e=
ffort
> is needed if you want manual caching. It requires 2 loops instead of 1 =
if you use
> FETCH N (N>1).

Ah, thanks for the explanation.

Michael
--=20
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=C3=A7a Bar=C3=A7a! Go SF 49ers! Use Debian GNU/Linux, P=
ostgreSQL