Vacuum VS Vacuum Analyze - Mailing list pgsql-general

From Matt Friedman
Subject Vacuum VS Vacuum Analyze
Date
Msg-id 00b201c0b3e6$8d744070$03284d18@mattq3h8budilr
Whole thread Raw
Responses Re: Vacuum VS Vacuum Analyze  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Been reading a number of the posts regarding vacuum and vacuum analyze.

I currently running vacuum nighly using cron and once in a while I run
vacuum analyze (as postgres).

Any reason why I wouldn't just simply run vacuum analyze each night?

Matt Friedman
Spry New Media
http://www.sprynewmedia.com
Lead Programmer/Partner
email: matt@sprynewmedia.com
phone: 250 744 3655
fax: 250 370 0436




pgsql-general by date:

Previous
From: Patrick Welche
Date:
Subject: Re: Migration from MSAccess
Next
From: will trillich
Date:
Subject: Re: Re: Re: Rules, views, sequences and returned values