Re: database speed
| От | Chris Stokes |
|---|---|
| Тема | Re: database speed |
| Дата | |
| Msg-id | 743ADEB2EC690A448790A8A9E5E16721065E46@confucius.melb.basssoftware.com обсуждение исходный текст |
| Ответ на | database speed ("Chris Stokes" <ChrisS@BassSoftware.com>) |
| Ответы |
Re: database speed
|
| Список | pgsql-general |
>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 longertoo. I have never used the REINDEX I wondered if it might be a row chaining issue of some sort ?!? Chris
В списке pgsql-general по дате отправления: