X-Original-To: pgsql-bugs@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 80D7247637E for ; Fri, 4 Apr 2003 09:53:25 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id B910947637A for ; Fri, 4 Apr 2003 09:53:24 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h34ErS2L005590; Fri, 4 Apr 2003 09:53:28 -0500 (EST) To: "Robert John Shepherd" Cc: pgsql-bugs@postgresql.org Subject: Re: Rapid deteriation of performance (might be caused by tsearch?) in 7.3.2 In-reply-to: <000201c2fa97$dc2197f0$f3b0313e@LAIKA> References: <000201c2fa97$dc2197f0$f3b0313e@LAIKA> Comments: In-reply-to "Robert John Shepherd" message dated "Fri, 04 Apr 2003 11:49:25 +0100" Date: Fri, 04 Apr 2003 09:53:28 -0500 Message-ID: <5589.1049468008@sss.pgh.pa.us> From: Tom Lane X-Spam-Status: No, hits=-29.1 required=5.0 tests=BAYES_00,EMAIL_ATTRIBUTION,IN_REP_TO,REFERENCES, REPLY_WITH_QUOTES 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/27 X-Sequence-Number: 5800 "Robert John Shepherd" writes: > Help! (And sorry if this is the wrong list) Yes, it's the wrong list. pgsql-performance would be the place to discuss this. We can't help you anyway without more details: show us the EXPLAIN ANALYZE results for some of the slow queries. (Ideally I'd like to see EXPLAIN ANALYZE for the same queries in both fast and slow states ...) regards, tom lane