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

From: "Peter T(dot) Breuer" <ptb(at)inv(dot)it(dot)uc3m(dot)es>
To: "Richard Huxton" <dev(at)archonet(dot)com>
Cc: ptb(at)inv(dot)it(dot)uc3m(dot)es, pgsql-performance(at)postgresql(dot)org
Subject: Re: general PG network slowness (possible cure) (repost)
Date: 2007-05-25 22:24:39
Message-ID: 200705252224.l4PMOd720862@inv.it.uc3m.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michal Szymanski 2007-05-25 22:27:02 Re: Big problem with sql update operation
Previous Message lists 2007-05-25 21:43:41 Adding disks/xlog & index