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

Re: Timeout error on pgstat

From: "Anibal David Acosta" <aa(at)devshock(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Timeout error on pgstat
Date: 2012-08-06 13:49:06
Message-ID: 005b01cd73da$41093680$c31ba380$@devshock.com (view raw or flat)
Thread:
Lists: pgsql-admin
Is probably that the cause of this behavior are many many dead tuples in the
table.?

 

 

 

 

De: Anibal David Acosta [mailto:aa(at)devshock(dot)com] 
Enviado el: miƩrcoles, 01 de agosto de 2012 04:27 p.m.
Para: pgsql-admin(at)postgresql(dot)org
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!!

pgsql-admin by date

Next:From: Terry SchmittDate: 2012-08-07 22:23:33
Subject: Data corruption after SAN snapshot
Previous:From: Haifeng LiuDate: 2012-08-06 10:50:47
Subject: How to make data changes inside trigger function visible to the top level statement ?

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