Re: [PERFORM] slower with the time

2003-07-01 Thread Juraj Porada
shared_buffers = 32 I don't have much experience in tuning the database, but I think there is a problem with a fragmentation of memory or so. I don't known backgrounds. Juraj Shridhar Daithankar schrieb: On Tuesday 01 July 2003 13:17, Juraj Porada wrote: I insert

[PERFORM] slower with the time

2003-07-01 Thread Juraj Porada
I insert data every second in my table. Every minute I delete from the table some row to keep max 1 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,