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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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!!
From | Date | Subject | |
---|---|---|---|
Next Message | Terry Schmitt | 2012-08-07 22:23:33 | Data corruption after SAN snapshot |
Previous Message | Haifeng Liu | 2012-08-06 10:50:47 | How to make data changes inside trigger function visible to the top level statement ? |