X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 97C289FB23B for ; Wed, 12 Jul 2006 23:49:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 35599-09 for ; Wed, 12 Jul 2006 23:48:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id 9C9499FB20E for ; Wed, 12 Jul 2006 23:48:57 -0300 (ADT) Received: (qmail 31982 invoked by uid 500); 13 Jul 2006 02:53:52 -0000 Date: Wed, 12 Jul 2006 21:53:52 -0500 From: Bruno Wolff III To: Medora Schauer Cc: postgresql Subject: Re: hyper slow after upgrade to 8.1.4 Message-ID: <20060713025352.GA27215@wolff.to> Mail-Followup-To: Bruno Wolff III , Medora Schauer , postgresql References: <1CA058827877644DAB54FB930FFA3B05A679AB@lincoln.FAIRIND.FAIRFIELD.COM> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1CA058827877644DAB54FB930FFA3B05A679AB@lincoln.FAIRIND.FAIRFIELD.COM> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/124 X-Sequence-Number: 19984 On Wed, Jul 12, 2006 at 15:41:14 -0500, Medora Schauer wrote: > I have just upgraded from 7.3.4 to 8.1.4 and now *all* db access calls > are extremely slow. I didn't need to preserve any old data so at this > point all my tables are empty. Just connecting to a db takes several > seconds. > > I know I'm not giving much to go on but I'm stumped. Can anyone suggest > how I might track down the cause of this problem? That connections are slow makes me think DNS is worth looking at. It might be that reverse lookups are timing out.