Skip site navigation (1) Skip section navigation (2)

Re: pgstat wait timeout

From: "Anibal David Acosta" <aa(at)devshock(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: pgstat wait timeout
Date: 2012-07-27 22:31:21
Message-ID: 002001cd6c47$8e3be460$aab3ad20$@devshock.com (view raw or flat)
Thread:
Lists: pgsql-performance
More information. 

 

After many "WARNING:  pgstat wait timeout" in the log also appear "ERROR:
canceling autovacuum task "

 

 

 

 

De: Anibal David Acosta [mailto:aa(at)devshock(dot)com] 
Enviado el: viernes, 27 de julio de 2012 06:04 p.m.
Para: pgsql-performance(at)postgresql(dot)org
Asunto: pgstat wait timeout

 

In my postgres log I saw a lot of warning like this.

 

WARNING:  pgstat wait timeout

 

Every 10 seconds aprox since yesterday and after one year working without
any warning

 

I have postgres 9.0.3 on a Windows Server 2008 R2.

 

I have only one big table with aprox. 1,300,000,000 (yes 1,300 millions)
rows the table is not used just keep historical record, could be this the
reason, some autovacuum over this table?

 

pg_stat_activity not show any autovacuum over this table but yes over the
transactional table, right now the autovacuum about transactional table is
taking 30 minutes (now() -  xact_start )

 

 

Thanks

 

pgsql-performance by date

Next:From: David BartonDate: 2012-07-28 04:33:17
Subject: Postgres 9.1.4 - high stats collector IO usage
Previous:From: Anibal David AcostaDate: 2012-07-27 22:03:33
Subject: pgstat wait timeout

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group