Re: VACUM database

Поиск
Список
Период
Сортировка
От Steve Wolfe
Тема Re: VACUM database
Дата
Msg-id 003501c0769c$ce191560$50824e40@iboats.com
обсуждение исходный текст
Ответ на VACUM database  (Uro Gruber <uros@sir-mag.com>)
Список pgsql-general
> I wan't to know how often do i have to do this. If i do a lot of
> inserts, my SELECTS are very slow, but if I Vacum the table it's
> better. do i have to vacum every insert?

      Not after every insert, but it should at least be done nightly and
after a large batch of inserts.  And make sure that you do 'vacuum analyze',
or alternatively, from the nightly postgres super-user cron,
'vacuumdb --all --analyze'.

steve



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

Предыдущее
От: "Oliver Elphick"
Дата:
Сообщение: Re: \connect
Следующее
От: "Oliver Elphick"
Дата:
Сообщение: Re: Inheritance and Foreign Keys