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

From: "marc(dot)hsiao" <marc(dot)hsiao(at)cobrasonic(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: How to turn autovacuum prevent wrap around run faster?
Date: 2011-01-07 08:14:41
Message-ID: 002c01cbae42$ef48eec0$cddacc40$@hsiao@cobrasonic.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Γιωργος Βαλκανας 2011-01-07 09:29:32 Re: "SELECT .. WHERE NOT IN" query running for hours
Previous Message Greg Smith 2011-01-07 04:37:45 Re: Wrong docs on wal_buffers?