Re: serious problems with vacuuming databases

From: Tomas Vondra <tv(at)fuzzy(dot)cz>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: serious problems with vacuuming databases
Date: 2006-04-09 21:49:22
Message-ID: 44398162.6060004@fuzzy.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> Huh, I didn't suggest to dump/reload. I suggested CLUSTER. You need to
> apply it only to tables where you have lots of dead tuples, which IIRC
> are A, C and D.

Sorry, I should read more carefully. Will clustering a table according
to one index solve problems with all the indexes on the table (if the
table has for example two indexes?).

t.v.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alvaro Herrera 2006-04-09 22:01:53 Re: serious problems with vacuuming databases
Previous Message Alvaro Herrera 2006-04-09 20:45:55 Re: serious problems with vacuuming databases