Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 4289F189E83A for ; Tue, 10 Apr 2012 11:37:44 -0300 (ADT) Received: from mail-qc0-f174.google.com ([209.85.216.174]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SHcCR-0004V9-Tl for pgsql-hackers@postgresql.org; Tue, 10 Apr 2012 14:37:43 +0000 Received: by qcro28 with SMTP id o28so3138751qcr.19 for ; Tue, 10 Apr 2012 07:37:26 -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=/LoVxdKeyXFUGpa01919lXxFXlx3rKoKknLq56F407s=; b=LNucw444PR4FOF5Jw/VyTOCUQEeyRxCEebx6fWDflutt7S3Ain72YeL2RwjQrLPl67 vV6gF/PNKVo8uMdjEooQMmRFnirdh5e37cj4lgG4G6s/W8hBDl2ojUVbxPAc3KK3kzfO OvT7i7wRC2C/qqkF3b3s5WnA5DnnIP7zMmpoVMfgvRxXZeq+vcdomMoinVi97CC+yNYt Qm9LBm7NpvVGJYWtkWQS8QLLOOTqOodMCDD9aSyYwy0ZTw7HFVN3EQN6hhF5KJxVhzNv JQAHPbL/jCLhuT3r3K8bL5Da7anZ3X31zXjYh0xnE8Oxvls0uE6ZInEEsvaqbBUVG0Fd qzvw== Received: by 10.224.59.194 with SMTP id m2mr14939694qah.46.1334068646216; Tue, 10 Apr 2012 07:37:26 -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 gs5sm80747qab.22.2012.04.10.07.37.24 (version=SSLv3 cipher=OTHER); Tue, 10 Apr 2012 07:37:25 -0700 (PDT) Date: Tue, 10 Apr 2012 10:37:22 -0400 From: Noah Misch To: Boszormenyi Zoltan Cc: Michael Meskes , Robert Haas , PG Hackers , Heikki Linnakangas , Bruce Momjian Subject: Re: ECPG FETCH readahead Message-ID: <20120410143722.GC6129@tornado.leadboat.com> References: <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> <20120408173859.GA4915@feivel.credativ.lan> <4F83E2B9.3030302@cybertec.at> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4F83E2B9.3030302@cybertec.at> User-Agent: Mutt/1.5.18 (2008-05-17) X-Gm-Message-State: ALoCoQkksag5zPfyL0chJ4WopQXvI1Uw9yFv+nOeiJbaeRbG99Ak3tnI8NCbIFMR4xpqqI8axkBL X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201204/463 X-Sequence-Number: 206266 On Tue, Apr 10, 2012 at 09:35:21AM +0200, Boszormenyi Zoltan wrote: > So, it's established that a specified READAHEAD N should not > be overridden. Even an explicit READAHEAD 1. > > Only a non-decorated cursor can be overridden, even if > a different default readahead window size is specified with > e.g. "ecpg -R 8". If ECPGFETCHSZ is not present, 8 will be used, > if ECPGFETCHSZ is present, its value will be used. ECPGopen() > will need an extra bool argument to distinguish this. > > Is this acceptable? Noah, Michael? Sounds perfect.