Re: [Slony1-general] WAL partition overloaded--by autovacuum?

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: [Slony1-general] WAL partition overloaded--by autovacuum?
Date: 2010-07-07 08:58:35
Message-ID: 4C3441BB.5020103@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 flush WAL files to /db/data/ couldn't keep up, thereby filling up the disk. I'm wondering if anyone else out there might be able to give me some insight or comments to my assessment--is it accurate? Any input would be helpful, and I'll try 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Yeb Havinga 2010-07-07 08:59:23 Re: Two different execution plan for the same request
Previous Message JOUANIN Nicolas (44) 2010-07-07 08:47:45 Re: Two different execution plan for the same request