X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 13D959FA30C for ; Mon, 5 Jun 2006 14:52:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 55192-05 for ; Mon, 5 Jun 2006 14:52:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mailbox.samurai.com (mailbox.samurai.com [205.207.28.82]) by postgresql.org (Postfix) with ESMTP id 0F7B89FA12F for ; Mon, 5 Jun 2006 14:52:30 -0300 (ADT) Received: from localhost (mailbox.samurai.com [205.207.28.82]) by mailbox.samurai.com (Postfix) with ESMTP id 03B9C61E56; Mon, 5 Jun 2006 13:52:29 -0400 (EDT) X-Virus-Scanned: by amavisd-new at mailbox.samurai.com Received: from mailbox.samurai.com ([205.207.28.82]) by localhost (mailbox.samurai.com [205.207.28.82]) (amavisd-new, port 10024) with LMTP id RocapZNHU+2L; Mon, 5 Jun 2006 13:52:27 -0400 (EDT) Received: from [192.168.1.103] (unknown [69.28.112.26]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by mailbox.samurai.com (Postfix) with ESMTP id C241761F82; Mon, 5 Jun 2006 13:52:26 -0400 (EDT) Subject: Re: [PERFORM] psql -A (unaligned format) eats too much From: Neil Conway To: Zoltan Boszormenyi Cc: Andrew Dunstan , Mark Woodward , Tom Lane , "Jim C. Nasby" , pgsql-hackers@postgresql.org In-Reply-To: <4484672B.8080606@dunaweb.hu> References: <44835834.2020309@dunaweb.hu> <44835F86.5040008@dunaweb.hu> <20060605152258.GT53487@pervasive.com> <20512.1149521250@sss.pgh.pa.us> <20060605155349.GU53487@pervasive.com> <20813.1149523235@sss.pgh.pa.us> <18006.24.91.171.78.1149526092.squirrel@mail.mohawksoft.com> <44845E86.3080001@dunslane.net> <4484672B.8080606@dunaweb.hu> Content-Type: text/plain Date: Mon, 05 Jun 2006 10:52:25 -0700 Message-Id: <1149529945.5577.5.camel@localhost> Mime-Version: 1.0 X-Mailer: Evolution 2.6.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/167 X-Sequence-Number: 84400 On Mon, 2006-06-05 at 19:17 +0200, Zoltan Boszormenyi wrote: > The general case cannot be applied for all particular cases. > E.g. you cannot use cursors from shell scripts This could be fixed by adding an option to psql to transparently produce SELECT result sets via a cursor. -Neil