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

Поиск
Список
Период
Сортировка
От Peter T. Breuer
Тема Re: general PG network slowness (possible cure) (repost)
Дата
Msg-id 200705252224.l4PMOd720862@inv.it.uc3m.es
обсуждение исходный текст
Ответ на Re: general PG network slowness (possible cure) (repost)  (Richard Huxton <dev@archonet.com>)
Ответы Re: general PG network slowness (possible cure) (repost)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
"Also sprach Richard Huxton:"
> > scheme each time, for example!  (how that?). I could presumably also
> > help it by preloading the commands I will run and sending over the
> > params only with a "do a no. 17 now!".
>
> PREPARE/EXECUTE (or the equivalent libpq functions).

Yes, thank you. It seems to speed things up by a factor of 2.

But can I prepare a DECLARE x BINARY CURSOR FOR SELECT ...  statement?
The manual seems to say no.

Peter

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

Предыдущее
От: lists@on-track.ca
Дата:
Сообщение: Adding disks/xlog & index
Следующее
От: Michal Szymanski
Дата:
Сообщение: Re: Big problem with sql update operation