Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 9E8939FB854 for ; Sat, 26 May 2007 13:46:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 13535-01 for ; Sat, 26 May 2007 13:46:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 212699FB646 for ; Sat, 26 May 2007 13:46:13 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l4QGkB85004568; Sat, 26 May 2007 12:46:11 -0400 (EDT) To: ptb@inv.it.uc3m.es cc: pgsql-performance@postgresql.org Subject: Re: general PG network slowness (possible cure) (repost) In-reply-to: <200705260707.l4Q77QO09110@inv.it.uc3m.es> References: <200705260707.l4Q77QO09110@inv.it.uc3m.es> Comments: In-reply-to "Peter T. Breuer" message dated "Sat, 26 May 2007 09:07:26 +0200" Date: Sat, 26 May 2007 12:46:11 -0400 Message-ID: <4567.1180197971@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/557 X-Sequence-Number: 24947 "Peter T. Breuer" writes: > "Also sprach Tom Lane:" >> No, you just prepare the SELECT. At the protocol level, DECLARE CURSOR >> is a tad useless. You can still fetch the data in binary if you want... > How? It's a 7.4 server (or may be, more generally) and declare binary > cursor is the only way I know to get binary data off it. AFAIR the only > other way works only for an 8.* server and consists of sending the query > with an annotation that a binary reply is expected. No, that works for a 7.4 server too; we haven't changed the protocol since then. (I forget though to what extent 7.4 libpq exposes the capability.) regards, tom lane