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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Sorry, I forgot to mention that archive_mode is "off" and commented out, and archive command is '' and commented out. 

Thanks for following up!
-- Richard

On Jul 7, 2010, at 1:58, Mark Kirkwood <mark.kirkwood@xxxxxxxxxxxxxxx> wrote:

> 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
> 
> -- 
> Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux