Re: Postgresql 9.0.6 alway run VACUUM ANALYZE pg_catalog.pg_attribute

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "tuanhoanganh" <hatuan05(at)gmail(dot)com>, "Jeff Davis" <pgsql(at)j-davis(dot)com>
Cc: "PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgresql 9.0.6 alway run VACUUM ANALYZE pg_catalog.pg_attribute
Date: 2012-06-29 14:13:12
Message-ID: 4FED71A80200002500048C14@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

tuanhoanganh <hatuan05(at)gmail(dot)com> wrote:

> VACUUM ANALYZE pg_catalog.pg_attribute, pg_catalog.pg_type,
> pg_catalog.pg_depend run all time of day.
>
> Is it normal in Postgres?

Do you create and drop a lot of tables (including temporary tables)?

What are the results of running the query on this page?:

http://wiki.postgresql.org/wiki/Server_Configuration

How is overall performance on the machine?

-Kevin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2012-06-29 14:53:33 Re: Notiffy problem
Previous Message Atri Sharma 2012-06-29 14:04:18 Re: Regarding parallel running of 9.1 and 9.2beta2