Re: serious problems with vacuuming databases - Mailing list pgsql-performance

From Tomas Vondra
Subject Re: serious problems with vacuuming databases
Date
Msg-id 44398162.6060004@fuzzy.cz
Whole thread Raw
In response to Re: serious problems with vacuuming databases  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: serious problems with vacuuming databases  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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.

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: serious problems with vacuuming databases
Next
From: Alvaro Herrera
Date:
Subject: Re: serious problems with vacuuming databases