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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alexander Korobov <akorobov(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problems with slow insert/delete queries/lot of disk write i/o in postgresql 7.2.4
Date: 2005-06-28 05:45:25
Message-ID: 11032.1119937525@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alexander Korobov <akorobov(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Youngblood 2005-06-28 05:59:48 Re: Generate a list of (days/hours) between two dates
Previous Message Gnanavel Shanmugam 2005-06-28 05:44:52 Re: Generate a list of (days/hours) between two dates