Tom Lane wrote:
Joe Conway <[EMAIL PROTECTED]> writes:
Since this database has many large, but static tables (i.e. new data is
loaded each day, but the tables are partitioned into year-month tables),
I'm thinking we can run VACUUM FREEZE on the whole database once, and
then run VACUUM FREEZE periodically on just the tables that have had
rows added since the last time -- is that correct?
That would work for the user tables, but the lesson to draw from this is
not to forget about the system catalogs ...
Right, I was just thinking about that too. Important safety tip :-)
Thanks again!
Joe
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
