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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ptb(at)inv(dot)it(dot)uc3m(dot)es
Cc: "Richard Huxton" <dev(at)archonet(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: general PG network slowness (possible cure) (repost)
Date: 2007-05-26 00:19:13
Message-ID: 28399.1180138753@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"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...

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Gregory Stark 2007-05-26 00:35:43 Re: Adding disks/xlog & index
Previous Message Tom Lane 2007-05-25 23:47:00 Re: Adding disks/xlog & index