slower with the time

From: Juraj Porada <porada(at)pe-muc(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: slower with the time
Date: 2003-07-01 07:47:17
Message-ID: 3F013C85.2060202@pe-muc.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Shridhar Daithankar 2003-07-01 07:48:00 Re: slower with the time
Previous Message Toby Sargeant 2003-07-01 03:19:23 excessive disk access during query