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
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 |