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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Aldor <an(at)mediaroot(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: VACUUM - Wow long should it take?! - Here are some test results
Date: 2005-08-28 16:46:52
Message-ID: 25202.1125247612@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Aldor <an(at)mediaroot(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Aldor 2005-08-28 18:48:51 Re: VACUUM - How long should it take?! - Here are some test
Previous Message Aldor 2005-08-28 16:01:25 VACUUM - Wow long should it take?! - Here are some test results