Re: VACUUM - Wow long should it take?! - Here are some test results - Mailing list pgsql-admin

From Tom Lane
Subject Re: VACUUM - Wow long should it take?! - Here are some test results
Date
Msg-id 25202.1125247612@sss.pgh.pa.us
Whole thread Raw
In response to VACUUM - Wow long should it take?! - Here are some test results  (Aldor <an@mediaroot.de>)
Responses Re: VACUUM - How long should it take?! - Here are some test  (Aldor <an@mediaroot.de>)
List pgsql-admin
Aldor <an@mediaroot.de> writes:
> bgwriter_percent = 0
> bgwriter_maxpages = 0

Why did you do that?  There's certainly nothing in the docs recommending
disabling the bgwriter.

> The duration of the VACUUM of tbl1 and tbl2 is okay - so how to speed up
> now the VACUUM of tbl3?

You have not showed us anything that would explain any speed differences
between these tables.  Maybe there was some difference in the data you
loaded them with?

            regards, tom lane

pgsql-admin by date:

Previous
From: Aldor
Date:
Subject: VACUUM - Wow long should it take?! - Here are some test results
Next
From: Aldor
Date:
Subject: Re: VACUUM - How long should it take?! - Here are some test