On 9/22/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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

I've finally found some time to spend on these tests. Here are the results:

* 8.2.5 *
- autovacuum off + ANALYZE: less than 16 minutes (figures previously
posted in this thread) - default configuration of 8.2
- autovacuum on, delay 0: 16m29
- autovacuum on, delay 20: 16m13
(I didn't repeat the run but we can see that autovacuum doesn't
introduce too much slowdown during the restore operation)

* 8.3devel freshly compiled  *
- autovacuum off: 14m39
- autovacuum on, delay 0: 15m32
- autovacuum on, delay 20: 51m37 (the box is idle during a large
amount of this time) - default configuration of 8.3devel

-- 
Guillaume

In response to

• Re: First steps with 8.3 and autovacuum launcher at 2007-09-22 15:38:52 from Tom Lane

Responses

• Re: First steps with 8.3 and autovacuum launcher at 2007-10-01 15:44:02 from Stefan Kaltenbrunner
• Re: First steps with 8.3 and autovacuum launcher at 2007-10-01 15:57:03 from Guillaume Smet

pgsql-hackers by date

Next:	From: Adrian Maier	Date: 2007-10-01 15:27:57
	Subject: Re: IDE
Previous:	From: Pedro Belmino	Date: 2007-10-01 13:42:23
	Subject: IDE