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

Поиск
Список
Период
Сортировка
От Peter T. Breuer
Тема Re: general PG network slowness (possible cure) (repost)
Дата
Msg-id 200705260707.l4Q77QO09110@inv.it.uc3m.es
обсуждение исходный текст
Ответ на Re: general PG network slowness (possible cure) (repost)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: general PG network slowness (possible cure) (repost)  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: general PG network slowness (possible cure) (repost)  ("Merlin Moncure" <mmoncure@gmail.com>)
Список pgsql-performance
"Also sprach Tom Lane:"
> "Peter T. Breuer" <ptb@inv.it.uc3m.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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ECC RAM really needed?
Следующее
От: Kristo Kaiv
Дата:
Сообщение: Re: Performance problem on 8.2.4, but not 8.2.3