"vacuum" and "cluster"

From: "Jimmy Choi" <JCHOI(at)altera(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: "vacuum" and "cluster"
Date: 2008-04-16 15:02:21
Message-ID: 6E3775AF29598B46AA3F102067A510F102835461@tor-ismsg01.altera.priv.altera.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Choi

Confidentiality Notice. This message may contain information that is confidential or otherwise protected from disclosure.
If you are not the intended recipient, you are hereby notified that any use, disclosure, dissemination, distribution,
or copying of this message, or any attachments, is strictly prohibited. If you have received this message in error,
please advise the sender by reply e-mail, and delete the message and any attachments. Thank you.

Browse pgsql-general by date

  From Date Subject
Next Message Jimmy Choi 2008-04-16 15:09:09 "vacuum" and "cluster"
Previous Message Dragan Zubac 2008-04-16 14:52:16 Re: Master-master replication with PostgreSQL