Postgres Pro
Downloads
Home   >   mailing lists

Timeout error on pgstat - Mailing list pgsql-admin

From Anibal David Acosta
Subject Timeout error on pgstat
Date
Msg-id 00dc01cd7024$07854340$168fc9c0$@devshock.com
Whole thread Raw
Responses Re: Timeout error on pgstat
List pgsql-admin
Tree view

I have a lot (maybe 1 every 10 seconds) of this error WARNING:  pgstat wait timeout

 

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.

 

Thanks!!

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: [pgsql] How bad is this full vacuum error?
Next
From: Craig Ringer
Date:
Subject: Re: Timeout error on pgstat