Re: Timeout error on pgstat

["Anibal David Acosta" <aa@xxxxxxxxxxxx>]

Is probably that the cause of this behavior are many many dead tuples in the table.?

 

 

 

 

De: Anibal David Acosta [mailto:aa@xxxxxxxxxxxx]
Enviado el: miércoles, 01 de agosto de 2012 04:27 p.m.
Para: pgsql-admin@xxxxxxxxxxxxxx
Asunto: Timeout error on pgstat

 

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!!