From: marc.hsiao <marc.hsiao@cobrasonic.com>
To: pgsql-performance@postgresql.org
Subject: Re: How to turn autovacuum prevent wrap around run faster?
Date: Fri, 7 Jan 2011 16:14:41 +0800
Message-ID: <002c01cbae42$ef48eec0$cddacc40$@hsiao@cobrasonic.com> (raw)
In-Reply-To: <000601cbaaea$28a5e120$79f1a360$@hsiao@cobrasonic.com>
References: <-121201471744211051@unknownmsgid>
<AANLkTi=39eEqo-5j4DxGTLq4akygP2_Uh-+ZfAmf1MPJ@mail.gmail.com>
<000601cbaaea$28a5e120$79f1a360$@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
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: marc.hsiao@cobrasonic.com
Subject: Re: How to turn autovacuum prevent wrap around run faster?
In-Reply-To: <002c01cbae42$ef48eec0$cddacc40$@hsiao@cobrasonic.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