Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group