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
Список
Дерево обсуждения
Re: Disk Utilization Increases And Time for Vacuum Increases. Jeff Boes <jboes@qtm.net>
Re: Disk Utilization Increases And Time for Vacuum Increases. "scott.marlowe" <scott.marlowe@ihs.com>
Re: Disk Utilization Increases And Time for Vacuum Increases. Bruce Momjian <pgman@candle.pha.pa.us>
Re: Disk Utilization Increases And Time for Vacuum Increases. Bruce Momjian <pgman@candle.pha.pa.us>
Re: Disk Utilization Increases And Time for Vacuum Increases. Bruce Momjian <pgman@candle.pha.pa.us>
Re: Disk Utilization Increases And Time for Vacuum Increases. Tom Lane <tgl@sss.pgh.pa.us>
>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 по дате отправления