Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 906C19FB6AF for ; Fri, 25 May 2007 10:03:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 58575-01 for ; Fri, 25 May 2007 10:03:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from cassarossa.samfundet.no (cassarossa.samfundet.no [129.241.93.19]) by postgresql.org (Postfix) with ESMTP id AD6D59FB6AD for ; Fri, 25 May 2007 10:03:30 -0300 (ADT) Received: from trofast.ipv6.sesse.net ([2001:700:300:1803:20e:cff:fe36:a766] helo=trofast.sesse.net) by cassarossa.samfundet.no with esmtp (Exim 4.50) id 1HrZS2-0000Y4-L7; Fri, 25 May 2007 15:03:26 +0200 Received: from sesse by trofast.sesse.net with local (Exim 3.36 #1 (Debian)) id 1HrZS2-0003cB-00; Fri, 25 May 2007 15:03:26 +0200 Date: Fri, 25 May 2007 15:03:26 +0200 From: "Steinar H. Gunderson" To: "Peter T. Breuer" Cc: pgsql-performance@postgresql.org Subject: Re: general PG network slowness (possible cure) (repost) Message-ID: <20070525130326.GA13820@uio.no> Mail-Followup-To: "Peter T. Breuer" , pgsql-performance@postgresql.org References: <200705250850.l4P8owm02940@inv.it.uc3m.es> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <200705250850.l4P8owm02940@inv.it.uc3m.es> X-Operating-System: Linux 2.6.20.4 on a x86_64 X-Message-Flag: Outlook? --> http://www.mozilla.org/products/thunderbird/ User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/497 X-Sequence-Number: 24887 On Fri, May 25, 2007 at 10:50:58AM +0200, Peter T. Breuer wrote: > I set up pg to replace a plain gdbm database for my application. Postgres and gdbm are completely different. You want to rethink your queries so each does more work, instead of running a zillion of them over the network. /* Steinar */ -- Homepage: http://www.sesse.net/