Horton

Re: First steps with 8.3 and autovacuum launcher

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Guillaume Smet" <guillaume.smet@gmail.com>
Cc: Decibel! <decibel@decibel.org>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2007-09-22T15:38:52Z
Lists: pgsql-hackers 
"Guillaume Smet" <guillaume.smet@gmail.com> writes:
> So a total of: 16 minutes for 8.2 compared to 53 minutes for 8.3 to
> have the database in the same state.

Please try that experiment with all three configurations on both
versions:
	* autovacuum off
	* autovacuum on, autovacuum_vacuum_cost_delay = 0
	* autovacuum on, autovacuum_vacuum_cost_delay = 20
Comparing apples and oranges isn't real helpful in determining
what's happening.

			regards, tom lane