Re: [GENERAL] problems with slow insert/delete queries/lot of disk write i/o in postgresql 7.2.4

2005-06-28 Thread Tom Lane
Alexander Korobov [EMAIL PROTECTED] writes: We are having strange problem on production system with very slow insert/delete commands and huge cpu and disk write activity spikes in postgresql 7.2.4. The first thing you should consider, if you are concerned about performance, is adopting a less

[GENERAL] problems with slow insert/delete queries/lot of disk write i/o in postgresql 7.2.4

2005-06-27 Thread Alexander Korobov
Hi, We are having strange problem on production system with very slow insert/delete commands and huge cpu and disk write activity spikes in postgresql 7.2.4. This behavior is very reproducible and happens in following sequence : 1. full db vacuum 2. several hundred of insert/delete commands are