From: marc47marc47 <marc47marc47@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: How to turn autovacuum prevent wrap around run faster?
Date: Thu, 6 Jan 2011 19:57:29 -0800 (PST)
Message-ID: <1294372649875-3331421.post@n5.nabble.com> (raw)
In-Reply-To: <001b01cba653$9910e9f0$cb32bdd0$@hsiao@cobrasonic.com>
References: <001b01cba653$9910e9f0$cb32bdd0$@hsiao@cobrasonic.com>
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-tp3319...
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: marc47marc47@gmail.com
Subject: Re: How to turn autovacuum prevent wrap around run faster?
In-Reply-To: <1294372649875-3331421.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox