Vacuum VS Vacuum Analyze

From: "Matt Friedman" <matt(at)daart(dot)ca>
To: "PgSql General List" <pgsql-general(at)postgresql(dot)org>
Subject: Vacuum VS Vacuum Analyze
Date: 2001-03-23 22:13:55
Message-ID: 00b201c0b3e6$8d744070$03284d18@mattq3h8budilr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sprynewmedia(dot)com
phone: 250 744 3655
fax: 250 370 0436

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matt Friedman 2001-03-23 22:18:48 ~* OR LIKE?
Previous Message will trillich 2001-03-23 22:11:56 Re: Re: Re: Rules, views, sequences and returned values