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 по дате отправления