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