From: Anibal David Acosta <aa@devshock.com>
To: pgsql-admin@postgresql.org
Subject: Re: Timeout error on pgstat
Date: Mon, 6 Aug 2012 09:49:06 -0400
Message-ID: <005b01cd73da$41093680$c31ba380$@devshock.com> (raw)
Is probably that the cause of this behavior are many many dead tuples in the
table.?
De: Anibal David Acosta [mailto:aa@devshock.com]
Enviado el: miércoles, 01 de agosto de 2012 04:27 p.m.
Para: pgsql-admin@postgresql.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!!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: aa@devshock.com
Subject: Re: Timeout error on pgstat
In-Reply-To: <005b01cd73da$41093680$c31ba380$@devshock.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox