autovacuum, any log? - Mailing list pgsql-performance

From Anibal David Acosta
Subject autovacuum, any log?
Date
Msg-id 00c501ccb4f5$b89966b0$29cc3410$@devshock.com
Whole thread Raw
Responses Re: autovacuum, any log?  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-performance

Hello, I have a postgres 9.0.2 installation.

Every works fine, but in some hours of day I got several timeout in my application (my application wait X seconds before throw a timeout).

Normally hours are not of intensive use, so I think that the autovacuum could be the problem.

 

Is threre any log where autovacuum write information about it self like “duration for each table” or any other relevante information.

 

Another inline question, should I exclude bigger tables from autovacuum or there are some mechanism to tell autovacuum to not run often on bigger tables (tables with more than 400 millions of rows)

 

Thanks!

pgsql-performance by date:

Previous
From: Christiaan Willemsen
Date:
Subject: Partitions and joins lead to index lookups on all partitions
Next
From: Tory M Blue
Date:
Subject: Re: pg_upgrade