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.
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 |