X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 360A9D6FA7 for ; Thu, 1 Sep 2005 15:52:49 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 91318-06 for ; Thu, 1 Sep 2005 18:52:32 +0000 (GMT) Received: from newman.lshift.net (host226.lshift.net [195.172.218.226]) by svr1.postgresql.org (Postfix) with ESMTP id 72C0AD86EB for ; Thu, 1 Sep 2005 15:52:30 -0300 (ADT) Received: (qmail 2963 invoked by uid 1004); 1 Sep 2005 18:52:31 -0000 Received: from 10.224.189.77 by newman (envelope-from , uid 64011) with qmail-scanner-1.24 (clamdscan: 0.80/627. Clear:RC:1(10.224.189.77):. Processed in 0.01388 secs); 01 Sep 2005 18:52:31 -0000 Received: from ponder.lshift.net (HELO localhost) ([10.224.189.77]) (envelope-sender ) by newman.lshift.net (qmail-ldap-1.03) with AES256-SHA encrypted SMTP for ; 1 Sep 2005 18:52:31 -0000 Date: Thu, 1 Sep 2005 19:52:31 +0100 From: Matthew Sackman To: pgsql-performance@postgresql.org Subject: Re: Massive performance issues Message-ID: <20050901185231.GA7131@pongo.lshift.net> Mail-Followup-To: pgsql-performance@postgresql.org References: <6EE64EF3AB31D5448D0007DD34EEB3417DD259@Herge.rcsinc.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <6EE64EF3AB31D5448D0007DD34EEB3417DD259@Herge.rcsinc.local> User-Agent: Mutt/1.5.10i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.093 required=5 tests=[AWL=0.093] X-Spam-Level: X-Archive-Number: 200509/13 X-Sequence-Number: 14321 On Thu, Sep 01, 2005 at 02:04:54PM -0400, Merlin Moncure wrote: > > Any help most gratefully received (even if it's to say that I should > be > > posting to a different mailing list!). > > this is correct list. did you run vacuum/analyze, etc? > Please post vacuum analyze times. 2005-09-01 19:47:08 LOG: statement: vacuum full analyze address; 2005-09-01 19:48:44 LOG: duration: 96182.777 ms 2005-09-01 19:50:20 LOG: statement: vacuum analyze address; 2005-09-01 19:51:48 LOG: duration: 87675.268 ms I run them regularly, pretty much after every bulk import. Matthew