Re: problems with slow insert/delete queries/lot of disk write i/o in postgresql 7.2.4 - Mailing list pgsql-general

From Tom Lane
Subject Re: problems with slow insert/delete queries/lot of disk write i/o in postgresql 7.2.4
Date
Msg-id 11032.1119937525@sss.pgh.pa.us
Whole thread Raw
In response to problems with slow insert/delete queries/lot of disk write i/o in postgresql 7.2.4  (Alexander Korobov <akorobov@gmail.com>)
List pgsql-general
Alexander Korobov <akorobov@gmail.com> 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 obsolete version of Postgres.

As a stopgap, increasing the checkpoint interval parameters might
help some.

            regards, tom lane

pgsql-general by date:

Previous
From: Gnanavel Shanmugam
Date:
Subject: Re: Generate a list of (days/hours) between two dates
Next
From: Tom Lane
Date:
Subject: Re: DANGER Windows version might hurt you