Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id D541C9FB979 for ; Fri, 25 May 2007 19:24:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 94277-02 for ; Fri, 25 May 2007 19:24:49 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from pop5-1.us4.outblaze.com (pop5-1.us4.outblaze.com [205.158.62.125]) by postgresql.org (Postfix) with SMTP id 541E99FB7A8 for ; Fri, 25 May 2007 19:24:49 -0300 (ADT) Received: (qmail 9858 invoked from network); 25 May 2007 22:25:10 -0000 Received: from unknown (HELO nbd.it.uc3m.es) (ptb:linuxmail.org?linuxmail.org@linuxmail.org@163.117.139.192) by pop5-1.us4.outblaze.com with SMTP; 25 May 2007 22:25:09 -0000 Received: from inv.it.uc3m.es (oboe.it.uc3m.es [163.117.139.101]) by nbd.it.uc3m.es (8.13.1/8.13.1/Debian-15) with ESMTP id l4PMOeOO021905; Sat, 26 May 2007 00:24:40 +0200 Received: (from ptb@localhost) by inv.it.uc3m.es (8.11.0/8.11.0) id l4PMOd720862; Sat, 26 May 2007 00:24:39 +0200 From: "Peter T. Breuer" Message-Id: <200705252224.l4PMOd720862@inv.it.uc3m.es> Subject: Re: general PG network slowness (possible cure) (repost) In-Reply-To: <4656EE15.6030101@archonet.com> from "Richard Huxton" at "May 25, 2007 03:09:25 pm" To: "Richard Huxton" Date: Sat, 26 May 2007 00:24:39 +0200 (MET DST) CC: ptb@inv.it.uc3m.es, pgsql-performance@postgresql.org X-Anonymously-To: Reply-To: ptb@inv.it.uc3m.es X-message-flag: Had your Outlook virus, today? http://www.counterpane.com/crypto-gram-0103.html#4 X-WebTV-Stationery: Standard\; BGColor=black\; TextColor=black Reply-By: Sat, 1 Apr 2006 14:21:08 -0700 X-Mailer: ELM [version 2.4ME+ PL66 (25)] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/542 X-Sequence-Number: 24932 "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