Re: Disk Utilization Increases And Time for Vacuum Increases.

From: Jeff Boes <jboes(at)qtm(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Disk Utilization Increases And Time for Vacuum Increases.
Date: 2003-08-25 02:16:32
Message-ID: 7da139a7e0dc3c55c41424237fcb737a@news.teranews.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2003-08-25 07:40:18 Re: Automated backup problems - pg_dump
Previous Message Curt Sampson 2003-08-25 01:28:53 Re: Disk Utilization Increases And Time for Vacuum Increases.