Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 2CFDB182A958 for ; Mon, 6 Aug 2012 10:49:27 -0300 (ADT) Received: from mail-gg0-f174.google.com ([209.85.161.174]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SyNgS-0001ej-Fs for pgsql-admin@postgresql.org; Mon, 06 Aug 2012 13:49:26 +0000 Received: by ggnl2 with SMTP id l2so2474370ggn.19 for ; Mon, 06 Aug 2012 06:49:10 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=from:to:references:in-reply-to:subject:date:message-id:mime-version :content-type:x-mailer:thread-index:content-language :x-gm-message-state; bh=qI6uhd1ceCchrYb89LLbBnPRA01dQvzWhsGCQ8pDQe4=; b=Xgc6JVtSfrdZ+yY/TwCGNhjAgGYxkl++VRN7YnjPzvc/3lokwztgaChgpNU3T4HA/d Fu2SZWB70uBRp/b4eauECtyusA4fdgarqFy36Sbju3jCmMnnYrqJWn4ufGGWmLhatjDr i2Tnd2gy5VxxgvzfdWdgJMLAEnZxUumZw50jaVOv0QZPSGs6eQTqbvumErsl5zerpAlH FApqkjIWQU9B+84nRfdZ6c9GyGFHpMJbLxOSDN6kzvUX7r+RoFJ5NJNk2+TOguMPViZx cbcx+QN6xs9GLfhzgfF/C0nGryu2jRlE0bEt0DF6WVmlsg2RmRYSLCoA+FtD4jAhYneV xnpg== Received: by 10.236.193.105 with SMTP id j69mr9944219yhn.21.1344260950418; Mon, 06 Aug 2012 06:49:10 -0700 (PDT) Received: from AnibalVAIO (host-1-86.b20.cvc.com.py. [186.2.211.86]) by mx.google.com with ESMTPS id t63sm31724188yhd.7.2012.08.06.06.49.08 (version=TLSv1/SSLv3 cipher=OTHER); Mon, 06 Aug 2012 06:49:09 -0700 (PDT) From: "Anibal David Acosta" To: References: In-Reply-To: Subject: Re: Timeout error on pgstat Date: Mon, 6 Aug 2012 09:49:06 -0400 Message-ID: <005b01cd73da$41093680$c31ba380$@devshock.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_005C_01CD73B8.B9F859D0" X-Mailer: Microsoft Outlook 14.0 Thread-Index: Ac1wI9c06zUgkksFQhS6iq4QmoIHtgDti30Q Content-Language: es-py X-Gm-Message-State: ALoCoQnuBdoif/CEQtjB0p3UuPdgA8V2lVWCpsXtB3+aJvGvpVEN4p9yRMr9TdS+kRFoGyPnb9cL X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201208/40 X-Sequence-Number: 39861 This is a multipart message in MIME format. ------=_NextPart_000_005C_01CD73B8.B9F859D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is probably that the cause of this behavior are many many dead tuples in the table.? =20 =20 =20 =20 De: Anibal David Acosta [mailto:aa@devshock.com]=20 Enviado el: mi=E9rcoles, 01 de agosto de 2012 04:27 p.m. Para: pgsql-admin@postgresql.org Asunto: Timeout error on pgstat =20 I have a lot (maybe 1 every 10 seconds) of this error WARNING: pgstat wait timeout =20 Also this=20 ERROR: canceling autovacuum task =20 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) =20 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. =20 Thanks!! ------=_NextPart_000_005C_01CD73B8.B9F859D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Is probably that the cause of this behavior are many many dea= d tuples in the table.?

<= span style=3D'color:#1F497D'>

De: Anibal David Acosta [mailto:aa@d= evshock.com]
Enviado el: mi=E9rcoles, 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 p= g_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 condi= tions, but this error is occurring about 1 week ago.

Thanks!!<= /p>

= ------=_NextPart_000_005C_01CD73B8.B9F859D0--