Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group