Quick Links

auto-vacuum vs. full table update

From:	Craig James <cjames(at)emolecules(dot)com>
To:	pgsql-performance(at)postgresql(dot)org
Subject:	auto-vacuum vs. full table update
Date:	2012-04-26 19:49:31
Message-ID:	CAFwQ8rd6G0r5oTTo=S=ONTHD797O_9NQLbAybTurPZE3i5ob5g@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-performance

An update to our system means I'm going to be rewriting every row of
some large tables (20 million rows by 15 columns). In a situation
like this, can auto-vacuum take care of it, or should I plan on
vacuum-full/reindex to clean up?

This is 8.4.4.

Thanks,
Craig

Responses

Re: auto-vacuum vs. full table update at 2012-04-26 19:53:32 from Joshua D. Drake
Re: auto-vacuum vs. full table update at 2012-04-26 20:00:19 from Steve Crawford
Re: auto-vacuum vs. full table update at 2012-04-26 20:11:07 from Kevin Grittner

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Joshua D. Drake	2012-04-26 19:53:32	Re: auto-vacuum vs. full table update
Previous Message	Thomas Kellerer	2012-04-26 19:38:11	Re: query optimization