Re: WAL partition overloaded--by autovacuum? - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: WAL partition overloaded--by autovacuum?
Date
Msg-id AANLkTik1oR2fMBp9pzpeYUgrANXKpK0B23scXONQEK1z@mail.gmail.com
Whole thread Raw
In response to WAL partition overloaded--by autovacuum?  (Richard Yen <richyen@iparadigms.com>)
Responses Re: [Slony1-general] WAL partition overloaded--by autovacuum?
List pgsql-performance
On Tue, Jul 6, 2010 at 7:10 PM, Richard Yen <richyen@iparadigms.com> wrote:
> This leads me to believe that there was a sudden flurry of write activity that occurred, and the process that would
flushWAL files to /db/data/ couldn't keep up, thereby filling up the disk.  I'm wondering if anyone else out there
mightbe able to give me some insight or comments to my assessment--is it accurate?  Any input would be helpful, and
I'lltry to make necessary architectural changes to keep this from happening again. 

I tend to agree.  What kind of disk setup is under your data store?
If it's RAID-5 or RAID-6 is it possibly degraded?

I'd run iostat -xd 10 while the write load it high to see how your
xlog partition %util compares to the main data store partition.

Do you have your main data store partition under a battery backed
caching RAID controller?  Tell us what you can about your hardware
setup.

pgsql-performance by date:

Previous
From: Richard Yen
Date:
Subject: WAL partition overloaded--by autovacuum?
Next
From: Scott Marlowe
Date:
Subject: Re: WAL partition overloaded--by autovacuum?