Re: How to turn autovacuum prevent wrap around run faster?

Поиск
Список
Период
Сортировка
От marc.hsiao
Тема Re: How to turn autovacuum prevent wrap around run faster?
Дата
Msg-id 002c01cbae42$ef48eec0$cddacc40$@hsiao@cobrasonic.com
обсуждение исходный текст
Ответ на Re: How to turn autovacuum prevent wrap around run faster?  ("marc.hsiao" <marc.hsiao@cobrasonic.com>)
Ответы Re: How to turn autovacuum prevent wrap around run faster?  ("marc.hsiao" <marc.hsiao@cobrasonic.com>)
Список pgsql-performance
Hi All:

The autovacuum (prevent wraparound) still run more than 36 hours, I can not
drop the partition table after adjust the autovacuum parameters.

If a table is running autovacuum (prevent wraparound), can I purge this
table?
If not, what else I can do for clean this partition table?

If the table is  running autovacuum (prevent wraparound), can I use pg_dump
to backup it?
Will the Transaction ID Wraparound Failures happen while table has been
restored into new DB?

Regards
Marc



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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Wrong docs on wal_buffers?
Следующее
От: kakarukeys
Дата:
Сообщение: Re: adding foreign key constraint locks up table