Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql 9.0.6 alway run VACUUM ANALYZE pg_catalog.pg_attribute - Mailing list pgsql-general

From tuanhoanganh
Subject Re: Postgresql 9.0.6 alway run VACUUM ANALYZE pg_catalog.pg_attribute
Date
Msg-id CAJg-yaNubOXgfp1zObgqWY=zK2bAeJs8XOsgE8MMqQjEte78wA@mail.gmail.com
Whole thread Raw
In response to Re: Postgresql 9.0.6 alway run VACUUM ANALYZE pg_catalog.pg_attribute  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: Postgresql 9.0.6 alway run VACUUM ANALYZE pg_catalog.pg_attribute  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-general
Tree view

Yes I have more than 10 activity connect on the database. 
But  VACUUM ANALYZE pg_catalog.pg_attribute, pg_catalog.pg_type, pg_catalog.pg_depend run all time of day.

Is it normal in Postgres?

Tuan Hoang Anh

On Fri, Jun 29, 2012 at 1:34 AM, Jeff Davis <pgsql@j-davis.com> wrote:
On Thu, 2012-06-28 at 21:41 +0700, tuanhoanganh wrote:
> Hello
> I am using PostgreSQL 9.0.6 64 bit on Windows 2003 64bit.
> When i view Postgresql status, there are some autovaccum alway run.
> Ex VACUUM ANALYZE pg_catalog.pg_attribute.
>
>
> Is it problem of PostgreSQL? Please help me.

Do you have activity on the database? If so, autovacuum is normal.

Regards,
       Jeff Davis



pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: create a script which imports csv data
Next
From: raghu ram
Date:
Subject: Re: function lookup using a "real" function call