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

Timeout error on pgstat

From: "Anibal David Acosta" <aa(at)devshock(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Timeout error on pgstat
Date: 2012-08-01 20:27:08
Message-ID: 00dc01cd7024$07854340$168fc9c0$ (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
I have a lot (maybe 1 every 10 seconds) of this error WARNING:  pgstat wait


Also this 

ERROR:  canceling autovacuum task


In the pg_stat_activity show an autovacuum process over a very used table
that runs about 1 hour and then this vacuum is cancelled (according to log)


I have Postgres 9.0.3 on a windows 2008 R2 running for about 1 year in same
conditions, but this error is occurring about 1 week ago.




pgsql-admin by date

Next:From: Craig RingerDate: 2012-08-02 02:00:41
Subject: Re: Timeout error on pgstat
Previous:From: Tom LaneDate: 2012-08-01 20:18:27
Subject: Re: [pgsql] How bad is this full vacuum error?

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