X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5F94FD1E8B2 for ; Wed, 21 Jan 2004 09:34:51 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 80883-02 for ; Wed, 21 Jan 2004 05:34:22 -0400 (AST) Received: from hercules.kiala.com (unknown [62.102.3.152]) by svr1.postgresql.org (Postfix) with ESMTP id 9B5FED1E8C7 for ; Wed, 21 Jan 2004 05:34:15 -0400 (AST) Received: from sandokan.lan.kiala.com (sandokan.lan.kiala.com [192.168.10.246]) by hercules.kiala.com (8.11.6/8.11.6) with SMTP id i0L9YHE28802 for ; Wed, 21 Jan 2004 10:34:17 +0100 Received: from jbaekelandt.dev.kiala.com ([192.168.7.231]) by sandokan.lan.kiala.com with Microsoft SMTPSVC(5.0.2195.6713); Wed, 21 Jan 2004 10:34:11 +0100 Subject: Really slow even after vacuum From: Jeroen Baekelandt To: pgsql-performance@postgresql.org Content-Type: text/plain Organization: Kiala Message-Id: <1074677650.2060.26.camel@jbaekelandt.dev.kiala.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Wed, 21 Jan 2004 10:34:10 +0100 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 21 Jan 2004 09:34:11.0945 (UTC) FILETIME=[BA2A9D90:01C3E001] X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/204 X-Sequence-Number: 5378 Hi, I must have missed something, because I get really slow performance from PG 7.3.4-RH. This is my situation: I have a table (jms_messages), which contains 500.000 records. select count(*) from jms_messages is understandable quite slow. Then I delete all of the records and add 1000 new ones. I run vacuumdb on this database and run select count(*) from jms_messages again. It takes 80 seconds!?! While before, with 1000 records, it took only a fraction of a second. Thanks for any tips, Jeroen Baekelandt