Re: Disk Utilization Increases And Time for Vacuum Increases.

Поиск
Список
Период
Сортировка
От Jeff Boes
Тема Re: Disk Utilization Increases And Time for Vacuum Increases.
Дата
Msg-id 7da139a7e0dc3c55c41424237fcb737a@news.teranews.com
обсуждение исходный текст
Ответ на Disk Utilization Increases And Time for Vacuum Increases.  ("Vikram D. Gaitonde" <vdgaitonde@yahoo.com>)
Ответы Re: Disk Utilization Increases And Time for Vacuum Increases.  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-admin
>One action we have consiously not done is "REINDEX" on the
>table. We want to avoid that as far as possible.

Why? It's usually a very painless step, unless the table has millions and
millions of rows. We reindex tables with multiple indexes and several million
rows on a weekly basis. The only downside is that the table seems to be quite
"busy" during the process, which only takes a few minutes.

AFAIK, VACUUM doesn't reclaim space taken up by indexes. In fact, the more
deletes you do, the larger the index space gets, and the *slower* the index
performs. A periodic REINDEX cleans up a lot of problems.


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

Предыдущее
От: Steve Santacroce
Дата:
Сообщение: pg_ctl won't start postgres, but postmaster will?!
Следующее
От: "Archie MacDonald (rsh)"
Дата:
Сообщение: readline-4.2a compile ,installation problem