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 E448030F616 for ; Tue, 1 Jul 2003 07:45:19 +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 98028-08 for ; Tue, 1 Jul 2003 04:45:09 -0300 (ADT) Received: from ns1.pe-muc.de (unknown [193.98.167.13]) by svr1.postgresql.org (Postfix) with ESMTP id 2FCCE310A54 for ; Tue, 1 Jul 2003 04:45:09 -0300 (ADT) Received: from pe-muc.de (tofana.pe-muc.de [193.98.167.253]) by ns1.pe-muc.de (PE Postfix Mail Server (Linux 7.3 i386)) with ESMTP id BA242F3882 for ; Tue, 1 Jul 2003 09:45:08 +0200 (CEST) Message-ID: <3F013C85.2060202@pe-muc.de> Date: Tue, 01 Jul 2003 09:47:17 +0200 From: Juraj Porada User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-DE; rv:1.0.1) Gecko/20020823 Netscape/7.0 X-Accept-Language: de-de, de MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: slower with the time Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200307/2 X-Sequence-Number: 2295 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? Thanks, Juraj Delete query: DELETE FROM tbl WHERE time_stamp >= 0.0 AND time_stamp < (SELECT max(time_stamp) FROM (SELECT time_stamp FROM tbl ORDER BY time_stamp, id_event_archive ASC LIMIT 222) AS t) PK: id_event_archive Index: time_stamp Postgres version: 7.3.3. OS: Solaris 2.8