Re: general PG network slowness (possible cure) (repost)

From: "Peter T(dot) Breuer" <ptb(at)inv(dot)it(dot)uc3m(dot)es>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: general PG network slowness (possible cure) (repost)
Date: 2007-05-26 07:07:26
Message-ID: 200705260707.l4Q77QO09110@inv.it.uc3m.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Also sprach Tom Lane:"
> "Peter T. Breuer" <ptb(at)inv(dot)it(dot)uc3m(dot)es> writes:
> > But can I prepare a DECLARE x BINARY CURSOR FOR SELECT ... statement?
> > The manual seems to say no.
>
> 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.

Peter

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kristo Kaiv 2007-05-26 12:41:27 Re: Performance problem on 8.2.4, but not 8.2.3
Previous Message Tom Lane 2007-05-26 04:19:27 Re: ECC RAM really needed?