X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 692E6475B85 for ; Mon, 7 Apr 2003 10:25:39 -0400 (EDT) Received: from mail.reviewer.co.uk (frodo.reviewer.co.uk [213.232.121.13]) by postgresql.org (Postfix) with SMTP id 0A5E6474E42 for ; Mon, 7 Apr 2003 10:25:38 -0400 (EDT) Received: (qmail 15483 invoked from network); 7 Apr 2003 14:25:38 -0000 Received: from unknown (HELO LAIKA) (62.49.176.243) by mail.reviewer.co.uk with SMTP; 7 Apr 2003 14:25:38 -0000 From: "Robert John Shepherd" To: "'Stephan Szabo'" Cc: Subject: Re: [BUGS] Rapid deteriation of performance (might be caused by tsearch?) in 7.3.2 Date: Mon, 7 Apr 2003 15:25:38 +0100 Message-ID: <002801c2fd11$8f893340$f3b0313e@LAIKA> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 In-Reply-To: <20030404072355.Q93368-100000@megazone23.bigpanda.com> X-Spam-Status: No, hits=-10.1 required=5.0 tests=BAYES_20,IN_REP_TO,QUOTED_EMAIL_TEXT,QUOTE_TWICE_1 autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/66 X-Sequence-Number: 1572 > > I've been running this daily: > > vacuumdb -h localhost -a -z > > Should I be using the full switch then? > > Well, you generally shouldn't need to if the fsm settings are high enough. > If you're doing really big updates like update each row of a 1 billion > row table, you may end up having to do one immediately following that. > Of course, if you're doing that, performance is probably not your biggest > concern. ;) Not doing that, no. ;) > Explain analyze'll tell us if the system is changing plans (presumably to > a worse one) It wasn't, oddly enough. I've added a new table that cuts down 85% of the work this query has to do, and it seems to have helped an awful lot at the moment. Of course only time will tell. :) Thanks for the suggestions. Yours Unwhettedly, Robert John Shepherd. Editor DVD REVIEWER The UK's BIGGEST Online DVD Magazine http://www.dvd.reviewer.co.uk For a copy of my Public PGP key, email: pgp@robertsworld.org.uk