X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 9D5CE9FA22C for ; Wed, 10 May 2006 00:29:52 -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 27602-03-5 for ; Wed, 10 May 2006 00:29:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 895FD9FA261 for ; Wed, 10 May 2006 00:29:44 -0300 (ADT) Received: from grzm.com (grzm.com [200.46.204.98]) by svr4.postgresql.org (Postfix) with ESMTP id BD2985B59C6 for ; Wed, 10 May 2006 03:26:47 +0000 (GMT) Received: from [172.16.1.101] (unknown [61.197.227.146]) by grzm.com (Postfix) with ESMTP id 321F8161B93B; Wed, 10 May 2006 04:26:45 +0100 (BST) In-Reply-To: <6EAB7E4D-59BC-42B7-93E8-3EE82AE9E4F0@rackspace.com> References: <1147167570.494108.284720@i39g2000cwa.googlegroups.com> <6EAB7E4D-59BC-42B7-93E8-3EE82AE9E4F0@rackspace.com> Mime-Version: 1.0 (Apple Message framework v749.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <068FA494-4DC0-4ECD-9876-408A535D3430@seespotcode.net> Cc: PostgreSQL Performance Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: PostgreSQL VACCUM killing CPU Date: Wed, 10 May 2006 12:24:55 +0900 To: Will Reese X-Mailer: Apple Mail (2.749.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/219 X-Sequence-Number: 19006 >> I have got such problem. >> Im running Postgresql 7.3.2 on Linux 2.6.13. Also, you should seriously consider upgrading. 8.1.3 is the current PostgreSQL release. If you must remain on 7.3, at least upgrade to 7.3.14, which contains many bugfixes. Michael Glaesemann grzm seespotcode net