Re: [PERFORM] slower with the time

2003-07-01 Thread Shridhar Daithankar
On Tuesday 01 July 2003 13:40, Juraj Porada wrote: > shared_buffers = 32 That is 32*8=256KB of memory. I thought default was 64. How much physical memory you have? I suggest you set it up something like 256 to start with. That may be too small as well but you haven't provided enough details to

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 data every sec

Re: [PERFORM] slower with the time

2003-07-01 Thread Shridhar Daithankar
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 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 t

[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,