[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] VACUUM - Wow long should it take?! - Here are some test results
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2005-08-28 16:46:52
Message-ID: 25202.1125247612 () sss ! pgh ! pa ! us
[Download RAW message or body]

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly
[prev in list] [next in list] [prev in thread] [next in thread]