Is probably that the cause of this behavior are many many dead tuples in the
table.?
De: Anibal David Acosta [mailto:a...@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 eve
r'
CC: 'pgsql-admin@postgresql.org'
Asunto: RE: [ADMIN] Timeout error on pgstat
Craig, those lines appear between pgstat timeout
ERROR: canceling autovacuum task
CONTEXT: automatic vacuum of table "XXX"
The table XXX is a table with about 200 insert p/ second
to de 2012 10:01 p.m.
Para: Anibal David Acosta
CC: pgsql-admin@postgresql.org
Asunto: Re: [ADMIN] Timeout error on pgstat
On 08/02/2012 04:27 AM, Anibal David Acosta wrote:
I have a lot (maybe 1 every 10 seconds) of this error WARNING: pgstat wait
timeout
A quick search suggests this can
Craig Ringer writes:
> On 08/02/2012 04:27 AM, Anibal David Acosta wrote:
>> I have a lot (maybe 1 every 10 seconds) of this error WARNING: pgstat
>> wait timeout
>>
> A quick search suggests this can be due to excessive I/O. However, this
> thread:
> http://postgresql.1045698.n5.nabble.com/pg
On 08/02/2012 04:27 AM, Anibal David Acosta wrote:
I have a lot (maybe 1 every 10 seconds) of this error WARNING: pgstat
wait timeout
A quick search suggests this can be due to excessive I/O. However, this
thread:
http://postgresql.1045698.n5.nabble.com/pgstat-wait-timeout-td5078125.html
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