Re: general PG network slowness (possible cure) (repost) - Mailing list pgsql-performance

From Tom Lane
Subject Re: general PG network slowness (possible cure) (repost)
Date
Msg-id 4567.1180197971@sss.pgh.pa.us
Whole thread Raw
In response to Re: general PG network slowness (possible cure) (repost)  ("Peter T. Breuer" <ptb@inv.it.uc3m.es>)
List pgsql-performance
"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

pgsql-performance by date:

Previous
From: mark@mark.mielke.cc
Date:
Subject: Re: ECC RAM really needed?
Next
From: Andrew Sullivan
Date:
Subject: Re: ECC RAM really needed?