Re: How to write a script to analyze and vacuum all the tables in the system catalog?Thanks. - Mailing list pgsql-general

From leaf_yxj
Subject Re: How to write a script to analyze and vacuum all the tables in the system catalog?Thanks.
Date
Msg-id 78e35489.26967.1376039ef2c.Coremail.leaf_yxj@163.com
Whole thread Raw
In response to Re: How to write a script to analyze and vacuum all the tables in the system catalog?Thanks.  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
Thanks. Steve


At 2012-05-18 02:54:36,"Steve Crawford [via PostgreSQL]" <[hidden email]> wrote:
On 05/17/2012 11:30 AM, leaf_yxj wrote:
> Hi Guys. Please help me about this.
>
> For postgres database, it looks like we need analyze and vacuum all the
> tables periodly.  I need to write a script which can be executed in crontab.
> I don't have any clues about that. I only know the command :
> analyze tablename;
> vacuum tablename;
Leave off the tablename to do the whole db. But (unless you are on a
really old version of PG) you really shouldn't need to manually vacuum
things as that is the job of the autovacuum process.

There are unusual situations that suggest a manual analyze. It should be
run right after a cluster for instance. But they are limited special cases.

What indicates that you need to vacuum or analyze via cron?

Cheers,
Steve


--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



To unsubscribe from How to write a script to analyze and vacuum all the tables in the system catalog?Thanks., click here.
NAML




View this message in context: Re:Re: How to write a script to analyze and vacuum all the tables in the system catalog?Thanks.
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Chris Angelico
Date:
Subject: Re: How to check for server availability? [v9.3.1, Linux]
Next
From: Steve Crawford
Date:
Subject: Re: How to write a script to analyze and vacuum all the tables in the system catalog?Thanks.