Re: database speed

Поиск
Список
Период
Сортировка
Искать
От
Chris Stokes
Тема
Re: database speed
Дата
Msg-id
743ADEB2EC690A448790A8A9E5E16721065E46@confucius.melb.basssoftware.com
Список
Дерево обсуждения
Re: database speed Vivek Khera <khera@kcilink.com>
Re: database speed Dennis Gearon <gearond@fireserve.net>

>You should periodically be doing:

>a) VACUUM (at least once a day, probably) and
>b) REINDEX 

>Are you doing both of these?  See the docs if you're not familiar with
>them.

>The REINDEX is needed because VACUUM doesn't free up index space in
>some circumstances.  7.4 (currently in late beta) will fix this.

Sorry Doug,

Yes I am doing a vacuum regularly - in fact, when the speed of the DB becomes slower, the vacuum takes longer and longer too.

I have never used the REINDEX

I wondered if it might be a row chaining issue of some sort ?!?

Chris
В списке pgsql-general по дате отправления
От: Doug McNaught
Дата:
Сообщение: Re: database speed
От: David Busby
Дата:
Сообщение: Best Perl Option?
FAQ