X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id B3EE7D1B516 for ; Mon, 8 Sep 2003 14:32:18 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 56420-04 for ; Mon, 8 Sep 2003 11:31:50 -0300 (ADT) Received: from mail.ipv6.estpak.ee (tunnelbroker.ipv6.estpak.ee [194.126.101.242]) by svr1.postgresql.org (Postfix) with ESMTP id DD49DD1B4E4 for ; Mon, 8 Sep 2003 11:31:45 -0300 (ADT) Received: from andri.ipv6.estpak.ee ([2001:7d0:0:10:202:a5ff:fe67:9c13]) by mail.ipv6.estpak.ee with esmtp (Exim 4.12) id 19wN3T-0004fm-00; Mon, 08 Sep 2003 17:31:47 +0300 From: Andri Saar To: Tom Lane Subject: Re: Serious issues with CPU usage Date: Mon, 8 Sep 2003 17:31:13 +0300 User-Agent: KMail/1.5.2 Cc: Hannu Krosing , pgsql-performance@postgresql.org References: <20030905215635.68C1173595@MX2.estpak.ee> <200309081350.23312.andris@estpak.ee> <9957.1063029873@sss.pgh.pa.us> In-Reply-To: <9957.1063029873@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200309081731.13136.andris@estpak.ee> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/122 X-Sequence-Number: 3488 On Monday 08 September 2003 17:04, Tom Lane wrote: > > It looks to me like throwing a plain VACUUM into your poller cycle > (or possibly VACUUM ANALYZE depending on how fast the table's stats > change) would solve your problems nicely. > I compled the pg_autovacuum daemon from 7.4beta sources as Shridhar Daithankar recommended, and it seems to work fine. At first glance I thought VACUUM is a thing you do maybe once per week during routine administration tasks like making a full backup, but I was wrong. Thanks to all for your help, we can consider this problem solved. Note to future generations: default postgres configuration settings are very conservative and don't be afraid to VACUUM very often. andri