Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 3088C632B2D for ; Thu, 24 Jun 2010 09:19:32 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 05607-01-4; Thu, 24 Jun 2010 12:19:23 +0000 (UTC) X-Greylist: delayed 00:08:45.760404 by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.10]) by mail.postgresql.org (Postfix) with ESMTP id 0A026635412; Thu, 24 Jun 2010 09:19:25 -0300 (ADT) Received: from feivel (exit.credativ.com [87.139.82.80]) by mrelayeu.kundenserver.de (node=mrbap1) with ESMTP (Nemesis) id 0ME45v-1OPsX73MOl-00HGdE; Thu, 24 Jun 2010 14:19:22 +0200 Received: by feivel (Postfix, from userid 1000) id 348BB10A807; Thu, 24 Jun 2010 14:19:22 +0200 (CEST) Date: Thu, 24 Jun 2010 14:19:22 +0200 From: Michael Meskes To: Heikki Linnakangas Cc: =?utf-8?B?QsO2c3rDtnJtw6lueWkgWm9sdMOhbg==?= , Bruce Momjian , Michael Meskes , PG Hackers , Hans-Juergen Schoenig Subject: Re: ECPG FETCH readahead Message-ID: <20100624121922.GD24137@feivel.credativ.lan> Mail-Followup-To: Heikki Linnakangas , =?utf-8?B?QsO2c3rDtnJtw6lueWkgWm9sdMOhbg==?= , Bruce Momjian , Michael Meskes , PG Hackers , Hans-Juergen Schoenig References: <201006232042.o5NKgb503695@momjian.us> <4C2308FD.1090300@cybertec.at> <4C231F9E.6000102@enterprisedb.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <4C231F9E.6000102@enterprisedb.com> User-Agent: Mutt/1.5.20 (2009-06-14) Content-Transfer-Encoding: quoted-printable X-Provags-ID: V01U2FsdGVkX1/q5MsgWELzc3qmQjrq1WjwOZZR9uPoiZFhYa/ 5yhpM64v72Mu/jdAOeepJxUdVxgsF4pLgMvA5UmQjG8IUzna7k aONQYLyTniAuxlBeHY4EA== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-5 required=5 tests=BAYES_50=0.8, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201006/1281 X-Sequence-Number: 164911 On Thu, Jun 24, 2010 at 12:04:30PM +0300, Heikki Linnakangas wrote: > Is there a reason not to enable it by default? I'm a bit worried > that it will receive no testing if it's not always on. Yes, there is a reason, namely that you don't need it in native mode at a= ll. ECPG can read as many records as you want in one go, something ESQL/C apparently cannot do. This patch is a workaround for that restriction. I = still do not really see that this feature gives us an advantage in native mode though.=20 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 ICQ 179140304, AIM/Yahoo/Skype michaelmeskes, Jabber meskes@jabber.org VfL Borussia! For=C3=A7a Bar=C3=A7a! Go SF 49ers! Use Debian GNU/Linux, P= ostgreSQL