Re: [Slony1-general] WAL partition overloaded--by autovacuum?
От | Richard Yen |
---|---|
Тема | Re: [Slony1-general] WAL partition overloaded--by autovacuum? |
Дата | |
Msg-id | 628D29CA-4776-422A-A9D5-9854F480CE43@richyen.com обсуждение исходный текст |
Ответ на | Re: [Slony1-general] WAL partition overloaded--by autovacuum? (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>) |
Список | pgsql-performance |
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@catalyst.net.nz> 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 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 > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance
В списке pgsql-performance по дате отправления: