From: Tom Lane <tgl@sss.pgh.pa.us>
To: ptb@inv.it.uc3m.es
Cc: pgsql-performance@postgresql.org
Subject: Re: general PG network slowness (possible cure) (repost)
Date: Sat, 26 May 2007 12:46:11 -0400
Message-ID: <4567.1180197971@sss.pgh.pa.us> (raw)
In-Reply-To: <200705260707.l4Q77QO09110@inv.it.uc3m.es>
References: <200705260707.l4Q77QO09110@inv.it.uc3m.es>
"Peter T. Breuer" <ptb@inv.it.uc3m.es> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, ptb@inv.it.uc3m.es
Subject: Re: general PG network slowness (possible cure) (repost)
In-Reply-To: <4567.1180197971@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox