Postgres Pro
Downloads
Home   >   mailing lists

Re: Vacuum VS Vacuum Analyze - Mailing list pgsql-general

From Tom Lane
Subject Re: Vacuum VS Vacuum Analyze
Date
Msg-id 10781.985387357@sss.pgh.pa.us
Whole thread Raw
In response to Vacuum VS Vacuum Analyze  ("Matt Friedman" <matt@daart.ca>)
Responses Re: Vacuum VS Vacuum Analyze  (Marek Pętlicki <marpet@buy.pl>)
List pgsql-general
Tree view 
"Matt Friedman" <matt@daart.ca> writes:
> 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?

If you can spare the cycles, you might as well make every vacuum a
vacuum analyze.

            regards, tom lane

pgsql-general by date:

Previous
From: culley harrelson
Date:
Subject: performance of ORDER BY random()
Next
From: Tom Lane
Date:
Subject: Re: ~* OR LIKE?