Postgres Pro
Downloads
Home   >   mailing lists

VACUUM vs VACUUM ANALYZE - Mailing list pgsql-general

From Mark Coffman
Subject VACUUM vs VACUUM ANALYZE
Date
Msg-id 00a101c15803$63b9ed40$91010a0a@npinfocorp.com
Whole thread Raw
In response to Re: To Postgres Devs : Wouldn't changing the select limit  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: VACUUM vs VACUUM ANALYZE  (Martijn van Oosterhout <kleptog@svana.org>)
Re: VACUUM vs VACUUM ANALYZE  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
I know the differences between VACUUM and VACUUM ANALYZE have been discussed
before, but I'd like to know how you schedule your cleaning jobs.  Right now
I do a

VACUUM
VACUUM ANALYZE

every hour... it takes about 3 minutes to run both.  Should I run ANALYZE
less often?

Mark
Epilogue.net

pgsql-general by date:

Previous
From: Flávio Brito
Date:
Subject: Re: Backup Postgre Windows to Linux
Next
From: "Holt, Jack C."
Date:
Subject: Re: Accessing PostgreSQL through Apache and PHP4 on Linux