Postgres Pro
Downloads
Home   >   mailing lists

Re: First steps with 8.3 and autovacuum launcher - Mailing list pgsql-hackers

From Tom Lane
Subject Re: First steps with 8.3 and autovacuum launcher
Date
Msg-id 16267.1190475532@sss.pgh.pa.us
Whole thread Raw
In response to Re: First steps with 8.3 and autovacuum launcher  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Responses Re: First steps with 8.3 and autovacuum launcher
Re: First steps with 8.3 and autovacuum launcher
Re: First steps with 8.3 and autovacuum launcher
List pgsql-hackers
Tree view 
"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

pgsql-hackers by date:

Previous
From: "Guillaume Smet"
Date:
Subject: Re: like/ilike improvements
Next
From: "Guillaume Smet"
Date:
Subject: Re: First steps with 8.3 and autovacuum launcher