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 0BD30D1B516 for ; Mon, 8 Sep 2003 11:13:28 +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 18002-03 for ; Mon, 8 Sep 2003 08:12:59 -0300 (ADT) Received: from smtp.pspl.co.in (www.pspl.co.in [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id 60BBDD1B505 for ; Mon, 8 Sep 2003 08:12:54 -0300 (ADT) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id h88BKZxc019443 for ; Mon, 8 Sep 2003 16:50:35 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) (authenticated bits=0) by persistent.co.in (8.12.9/8.12.9) with ESMTP id h88BKXsv019429 for ; Mon, 8 Sep 2003 16:50:33 +0530 From: "Shridhar Daithankar" To: pgsql-performance@postgresql.org Date: Mon, 08 Sep 2003 16:44:56 +0530 MIME-Version: 1.0 Subject: Re: Serious issues with CPU usage Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3F5CB208.7522.1539792D@localhost> In-reply-to: <200309081350.23312.andris@estpak.ee> References: <28675.1062806700@sss.pgh.pa.us> X-mailer: Pegasus Mail for Windows (v4.12a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/119 X-Sequence-Number: 3485 On 8 Sep 2003 at 13:50, Andri Saar wrote: > If this is the best you can get with postgres right now, then I'll just have > to increase the frequency of VACUUMing, but that feels like a hackish > solution :( Use a autovacuum daemon. There is one in postgresql contrib module. It was introduced during 7.4 development and it works with 7.3.x. as well. Current 7.4CVS head has some problems with stats collector but soon it should be fine. Check it out.. Bye Shridhar -- Punishment becomes ineffective after a certain point. Men become insensitive. -- Eneg, "Patterns of Force", stardate 2534.7