Can autovacuum result in large surges in WAL files

Поиск
Список
Период
Сортировка
От Todd Gugler
Тема Can autovacuum result in large surges in WAL files
Дата
Msg-id CBFC2500-5ADB-48FD-AC3B-C450E02E9F6A@gmail.com
обсуждение исходный текст
Ответы Re: Can autovacuum result in large surges in WAL files  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-admin
I have a Postgres 8.3 system that is configured to run autovacuum.  It triggered a vacuum analyze on multiple tables
andsince this started, we are getting large numbers of WAL files generated about every 15 minutes or so.  This same
vacuumappears to continuing to run.  Other database activity is at its usual levels.  Should a vacuum analyze lead to
largeamounts of data being written to WAL files?  We are seeing 10x the number WAL files that we would expect. 

Any ideas on the best approach to diagnose what is going on?

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Mark Johnson"
Дата:
Сообщение: Re: Can we Flush the Postgres Shared Memory ?
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Can autovacuum result in large surges in WAL files