Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 4D6A91337BBC for ; Fri, 7 Jan 2011 04:15:04 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 36257-06 for ; Fri, 7 Jan 2011 08:14:57 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.cobrasonic.com (250.57.145.202.adsl.static.ttn.net [202.145.57.250]) by mail.postgresql.org (Postfix) with ESMTP id DA18E1337BBB for ; Fri, 7 Jan 2011 04:14:54 -0400 (AST) Received: from marcU45J (pc123184 [192.168.123.184]) (authenticated bits=0) by mail.cobrasonic.com (8.14.1/8.14.1) with ESMTP id p078EqTq017589 for ; Fri, 7 Jan 2011 16:14:53 +0800 From: "marc.hsiao" To: References: <-121201471744211051@unknownmsgid> <000601cbaaea$28a5e120$79f1a360$@hsiao@cobrasonic.com> In-Reply-To: <000601cbaaea$28a5e120$79f1a360$@hsiao@cobrasonic.com> 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> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AcumViSAZn9an7XiRMqWn2mo38ueAAEkzBwwANZinOA= Content-Language: zh-tw X-cobrasonic-MailScanner-Information: Please contact the ISP for more information X-cobrasonic-MailScanner-ID: p078EqTq017589 X-cobrasonic-MailScanner: Not scanned: please contact your Internet E-Mail Service Provider for details X-cobrasonic-MailScanner-From: marc.hsiao@cobrasonic.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=-10 required=5 tests=BAYES_20=-0.001, MSGID_MULTIPLE_AT=0.001 X-Spam-Level: X-Archive-Number: 201101/36 X-Sequence-Number: 41823 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