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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: VACUUM - Wow long should it take?! - Here are some test results
Дата
Msg-id 25202.1125247612@sss.pgh.pa.us
обсуждение исходный текст
Ответ на VACUUM - Wow long should it take?! - Here are some test results  (Aldor <an@mediaroot.de>)
Ответы Re: VACUUM - How long should it take?! - Here are some test  (Aldor <an@mediaroot.de>)
Список 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 по дате отправления:

Предыдущее
От: Aldor
Дата:
Сообщение: VACUUM - Wow long should it take?! - Here are some test results
Следующее
От: Aldor
Дата:
Сообщение: Re: VACUUM - How long should it take?! - Here are some test