ql.org] On Behalf Of marc.hsiao
Sent: Friday, January 07, 2011 4:15 PM
To: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] How to turn autovacuum prevent wrap around run
faster?
Hi All:
The autovacuum (prevent wraparound) still run more than 36 hours, I can not
drop the partition table af
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 t
---Original Message-
From: pgsql-performance-ow...@postgresql.org
[mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of Scott Marlowe
Sent: Tuesday, December 28, 2010 2:12 PM
To: marc.hsiao
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] How to turn autovacuum prevent wrap ar
Hi ALL:
My Database is for logs only, I almost have 30G data growth in my database.
I Use partition table to store those data, those tables are partitioned by
time column daily.
My data only keep for three days.
I will dump those data into dump file and drop the partition table after
three d
