| From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
|---|---|
| To: | leaf_yxj <leaf_yxj(at)163(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to write a script to analyze and vacuum all the tables in the system catalog?Thanks. |
| Date: | 2012-05-17 18:53:15 |
| Message-ID: | 4FB5491B.9030308@pinpointresearch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | leaf_yxj | 2012-05-17 18:54:06 | How to debug the performance issues via which system catalog.Thanks. |
| Previous Message | leaf_yxj | 2012-05-17 18:30:46 | How to write a script to analyze and vacuum all the tables in the system catalog?Thanks. |