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

Поиск
Список
Период
Сортировка
От marc47marc47
Тема Re: How to turn autovacuum prevent wrap around run faster?
Дата
Msg-id 1294372649875-3331421.post@n5.nabble.com
обсуждение исходный текст
Ответ на 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
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-to-turn-autovacuum-prevent-wrap-around-run-faster-tp3319984p3331421.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

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

Предыдущее
От: Marc Antonio
Дата:
Сообщение: Re: Major performance problem after upgrade from 8.3 to 8.4
Следующее
От: Γιωργος Βαλκανας
Дата:
Сообщение: Re: "SELECT .. WHERE NOT IN" query running for hours