X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 44DEB310B49 for ; Tue, 1 Jul 2003 07:49:08 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 97354-08 for ; Tue, 1 Jul 2003 04:48:57 -0300 (ADT) Received: from www.pspl.co.in (www.pspl.co.in [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id 4B779310AE8 for ; Tue, 1 Jul 2003 04:48:56 -0300 (ADT) Received: (from root@localhost) by www.pspl.co.in (8.11.6/8.11.6) id h617mtM10159 for ; Tue, 1 Jul 2003 13:18:55 +0530 Received: from daithan.intranet.pspl.co.in (daithan.intranet.pspl.co.in [192.168.7.161]) by www.pspl.co.in (8.11.6/8.11.0) with ESMTP id h617mtg10154 for ; Tue, 1 Jul 2003 13:18:55 +0530 From: Shridhar Daithankar To: pgsql-performance@postgresql.org Subject: Re: slower with the time Date: Tue, 1 Jul 2003 13:18:00 +0530 User-Agent: KMail/1.5.2 References: <3F013C85.2060202@pe-muc.de> In-Reply-To: <3F013C85.2060202@pe-muc.de> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200307011318.00824.shridhar_daithankar@nospam.persistent.co.in> X-Archive-Number: 200307/3 X-Sequence-Number: 2296 On Tuesday 01 July 2003 13:17, Juraj Porada wrote: > I insert data every second in my table. Every minute I delete from the > table some row to keep max 10000 rows in the table. > At the beginning deletes consume about 20% CPU time. After 24 houts > every delete needs up tu 100% CPU time (updates too). > Vacuuming doesn't help. > After I restart postmaster, it works again very quick. > Any ideas? Postmaster does not consume CPU for simple things like this unless it does not have enough shared buffers. What is your shared buffer setting? Can you tune it according to available RAM, dataset size and type of workload? Shridhar