Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 2EF9B11ADB8A for ; Sat, 7 Apr 2012 12:51:00 -0300 (ADT) Received: from mail-qa0-f53.google.com ([209.85.216.53]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SGXuk-0000Ou-NS for pgsql-hackers@postgresql.org; Sat, 07 Apr 2012 15:50:59 +0000 Received: by qadc11 with SMTP id c11so800476qad.19 for ; Sat, 07 Apr 2012 08:50:45 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=date:from:to:cc:subject:message-id:references:mime-version :content-type:content-disposition:in-reply-to:user-agent :x-gm-message-state; bh=uKCPPZlbUZr0zLqAywQ7BU2mpr0TyMN3UDFoWka9FNk=; b=MERwsl8dRSmnJitFqJajCB9+rqnEBJAEsoZD3cJ10AFPSYRZP0OBSJo2hTVD5B01n1 RdKX6S/D3GX0tS6P5UNE4WIMXhRwKA4d58CeFG5MwP+Xj7RYOhZ6giyCkLZBQSnDYkvk W//9ZGgZW1yTeFRVZuAVzeUyq9whyQTk2WLleZO8Zn6JxhAYqkMrLBV+cFD8WtX4Hs19 mc3889ykJTjKBJ7BVLA88iJV/upWZrQdHeMWW+7/iCWOL5vL3xSXhYn2IOh4wgmpAPXw t1DSE7fMDmKHh2gBLm8AABUjQLx5UIH/JUAZROMp7vyUZPJmW5/iCEUj+Hn9mC3uazzu A/Og== Received: by 10.224.35.130 with SMTP id p2mr2213021qad.32.1333813845693; Sat, 07 Apr 2012 08:50:45 -0700 (PDT) Received: from tornado.leadboat.com (ip68-105-236-221.hr.hr.cox.net. [68.105.236.221]) by mx.google.com with ESMTPS id dv7sm16162985qab.15.2012.04.07.08.50.44 (version=SSLv3 cipher=OTHER); Sat, 07 Apr 2012 08:50:45 -0700 (PDT) Date: Sat, 7 Apr 2012 11:50:42 -0400 From: Noah Misch To: Michael Meskes Cc: Boszormenyi Zoltan , Robert Haas , PG Hackers , Heikki Linnakangas , Bruce Momjian Subject: Re: ECPG FETCH readahead Message-ID: <20120407155042.GB11987@tornado.leadboat.com> References: <20120305185632.GE13348@tornado.leadboat.com> <4F55A9AD.6050600@cybertec.at> <20120306110658.GC15988@tornado.leadboat.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> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20120407112008.GA2286@feivel.credativ.lan> User-Agent: Mutt/1.5.18 (2008-05-17) X-Gm-Message-State: ALoCoQmuheSpCUPSeZE6WBXj2YdOyzt9ZW4HaLv+pSpynCu6OHwUfsTfuMYWZhBWdF1Yzsfgt57P X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201204/337 X-Sequence-Number: 206140 On Sat, Apr 07, 2012 at 01:20:08PM +0200, Michael Meskes wrote: > On Fri, Mar 30, 2012 at 12:48:07AM +0200, Boszormenyi Zoltan wrote: > > Attached is the new core feature patch. Summary of changes: > > ... > > I also refreshed the second patch that drives all cursors with the new > > ... > > I'm slightly confused here. It seems Zoltan added a second patch *after* Noah > marked this patch as ready for committer. That second patch seems to apply > cleanly after the first one got applied. Now, which one was reviewed and is > considered ready for commit? The first one? Or both? Both. The second patch appeared after my first review, based on a comment in that review. I looked at it during my re-review before marking the overall project Ready for Committer. 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