Vacuum, reindex, cluster, in propper order ?

From: "NTPT" <ntpt(at)centrum(dot)cz>
To: "Pg-General" <pgsql-general(at)postgresql(dot)org>
Subject: Vacuum, reindex, cluster, in propper order ?
Date: 2004-06-15 22:03:08
Message-ID: 004801c45324$8adcc9f0$74beebd5@wbp1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi. I need to do some routine maintance task drived by crontab. It is vacuuming, reindexing an clustering for faster access.

So I need to ask, what order of commands is correct for best performance and low maintance window ? I do not found any word of it in the documentation. i use pg 7.3.2

1: vacuuum full analyze
2: reindex table foo (and other tables)
3: cluster table foo (and other tables) on indexname
4: vacuum analyze

thanx for help

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2004-06-15 23:04:06 Re: perl access
Previous Message elein 2004-06-15 22:00:14 Re: postgresql.conf for pg_stat_activity