How to write a script to analyze and vacuum all the tables in the system catalog?Thanks.

From: leaf_yxj <leaf_yxj(at)163(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to write a script to analyze and vacuum all the tables in the system catalog?Thanks.
Date: 2012-05-17 18:30:46
Message-ID: 1337279446660-5709059.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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;

Please helps.

Thanks.

Regards.

Grace

--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-write-a-script-to-analyze-and-vacuum-all-the-tables-in-the-system-catalog-Thanks-tp5709059.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2012-05-17 18:53:15 Re: How to write a script to analyze and vacuum all the tables in the system catalog?Thanks.
Previous Message Tom Lane 2012-05-17 18:12:15 Re: cannot compile www_fdw Foreign Data Wrapper