Re: [Slony1-general] WAL partition overloaded--by autovacuum? - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: [Slony1-general] WAL partition overloaded--by autovacuum?
Date
Msg-id 4C3441BB.5020103@catalyst.net.nz
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 07/07/10 13:10, Richard Yen 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. 
>

Do you have wal archiving enabled? (if so lets see your archive_command).

Cheers

Mark

pgsql-performance by date:

Previous
From: Yeb Havinga
Date:
Subject: Re: Two different execution plan for the same request
Next
From: Guillaume Smet
Date:
Subject: Re: Two different execution plan for the same request