Re: Postgresql 9.0.6 alway run VACUUM ANALYZE pg_catalog.pg_attribute

From: tuanhoanganh <hatuan05(at)gmail(dot)com>
To: 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 07:15:50
Message-ID: CAJg-yaNubOXgfp1zObgqWY=zK2bAeJs8XOsgE8MMqQjEte78wA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)j-davis(dot)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
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message raghu ram 2012-06-29 07:42:41 Re: function lookup using a "real" function call
Previous Message Craig Ringer 2012-06-29 03:01:37 Re: create a script which imports csv data