Re: Vacuum full is slow

Поиск
Список
Период
Сортировка
От Ruben Rubio
Тема Re: Vacuum full is slow
Дата
Msg-id 45FE9C4B.7070602@rentalia.com
обсуждение исходный текст
Ответ на Re: Vacuum full is slow  (Heikki Linnakangas <heikki@enterprisedb.com>)
Ответы Re: Vacuum full is slow  ("Shoaib Mir" <shoaibmir@gmail.com>)
Список pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

>
> You don't have vacuum_cost_delay set, do you? How long does normal
> vacuum run?

vacuum_cost_delay = 100
No idea how long will take normal vacuum. I ll try tonight when there is
not too much load.

>
> The manual suggests dropping all indexes before running vacuum full, and
> recreating them afterwards. That's worth trying.
>

I ll try that also. Is there any way to do it? Do i have to delete /
create each one manually?

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFF/pxLIo1XmbAXRboRAjR1AJ9V4kBDCd++HSmUm8+ZCLs2RY0xnACfZ7Mp
uBC031TFhO2NGOihfWPAQQ8=
=QCYi
-----END PGP SIGNATURE-----

В списке pgsql-performance по дате отправления:

Предыдущее
От: Vincenzo Romano
Дата:
Сообщение: Re: text equality worse than pattern matching (v8.1.8)
Следующее
От: "Shoaib Mir"
Дата:
Сообщение: Re: Vacuum full is slow