Re: Long Running Commits - Not Checkpoints

From: db(at)zigo(dot)dhs(dot)org
To: "Brad Nicholson" <bnichols(at)ca(dot)afilias(dot)info>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Long Running Commits - Not Checkpoints
Date: 2007-09-14 11:31:45
Message-ID: 43618.192.121.104.48.1189769505.squirrel@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> I'm having a problem with long running commits appearing in my database
> logs. It may be hardware related, as the problem appeared when we moved
> the database to a new server connected to a different disk array. The
> disk array is a lower class array, but still more than powerful enough
> to handle the IO requirements. One big difference though is that the
> old array had 16 GB of cache, the new one has 4 GB.

Maybe the old disk array had battery backed up ram that was used as a
write cache and the new only has read cache? Without battery backed up ram
(or flash or whatever) then a commit need to flush data down onto the
pysical disk.

/Dennis

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ansgar -59cobalt- Wiechers 2007-09-14 12:03:21 Re: Regarding COPY command from Postgres 8.2.0
Previous Message soni de 2007-09-14 10:21:51 Regarding COPY command from Postgres 8.2.0