Setting vacuum_mem for vacuumdb utility

Поиск
Список
Период
Сортировка
От Jeff Boes
Тема Setting vacuum_mem for vacuumdb utility
Дата
Msg-id a493d97acab9a60c7ca9f5dd568b5e8f@news.teranews.com
обсуждение исходный текст
Ответы Re: Setting vacuum_mem for vacuumdb utility
Список pgsql-admin
I just discovered that the use of a much larger setting on vacuum_mem
has a joyous effect on the throughput of VACUUM FULL for some of our
tables. However, all of my maintenance scripts use "vacuumdb" (the
command-line utility) instead of psql. How can I set vacuum_mem for the
duration of the vacuumdb command's execution?



--
Jeff Boes                                      vox 269.226.9550 ext 24
Database Engineer                                     fax 269.349.9076
Nexcerpt, Inc.                                 http://www.nexcerpt.com
            ...Nexcerpt... Extend your Expertise

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

Предыдущее
От: "Frank Smith"
Дата:
Сообщение: Performance Problem
Следующее
От: "Ivaylo Mutafchiev"
Дата:
Сообщение: Re: [Cross-post] initdb failed on Windows 2003 Advanced Server