"vacuum" and "cluster" - Mailing list pgsql-general

From Jimmy Choi
Subject "vacuum" and "cluster"
Date
Msg-id 5770602b0804160809j6cb5937t4a30858f645e64d3@mail.gmail.com
Whole thread Raw
Responses Re: "vacuum" and "cluster"  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
Hello,

Does running "cluster" remove the need to run "vacuum"?

I get a feeling that since cluster is already physically reordering
the rows, it may as well remove the dead rows... no?

My second question is, if vacuum is still needed, does it matter
whether I run vacuum first or cluster first?

Here's our current weekly db maintenance routine:

1. vacuum full
2. cluster
3. reindex
4. analyze

Thanks,
Jimmy

pgsql-general by date:

Previous
From: Dragan Zubac
Date:
Subject: Re: Master-master replication with PostgreSQL
Next
From: Karsten Hilbert
Date:
Subject: Re: Storage sizes for dates/times (documentation bug?)