Re: How to turn autovacuum prevent wrap around run faster? - Mailing list pgsql-performance

From marc47marc47
Subject Re: How to turn autovacuum prevent wrap around run faster?
Date
Msg-id 1294372649875-3331421.post@n5.nabble.com
Whole thread Raw
In response to How to turn autovacuum prevent wrap around run faster?  ("marc.hsiao" <marc.hsiao@cobrasonic.com>)
List 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 by date:

Previous
From: Marc Antonio
Date:
Subject: Re: Major performance problem after upgrade from 8.3 to 8.4
Next
From: Γιωργος Βαλκανας
Date:
Subject: Re: "SELECT .. WHERE NOT IN" query running for hours