Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 9330A152A2F9 for ; Fri, 27 Jul 2012 19:03:54 -0300 (ADT) Received: from mail-gh0-f174.google.com ([209.85.160.174]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SusdS-0001Gx-0V for pgsql-performance@postgresql.org; Fri, 27 Jul 2012 22:03:53 +0000 Received: by ghrr11 with SMTP id r11so3723432ghr.19 for ; Fri, 27 Jul 2012 15:03:35 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=from:to:subject:date:message-id:mime-version:content-type:x-mailer :thread-index:content-language:x-gm-message-state; bh=vSbjgmWNoZjYk2K8mj9Wi3QW1sb27Dy0ZOiH/EwC1GU=; b=EBLPKhmCpX0KI26JZ0p9sEASfKNnBohYrO7H75KxeJoqTy/nuOjxIGBgVeW2jdrh0A 5RpynPxJD+mzle+/AjzCAIlaN7DMBH3zrAMZy/HouFcZY1GXNwJJDYPrDr+uJQlyzX6w ptjLWKn9swufWFlhq2kNWZpLYsewc0FIbCvuqzmaJqCJ+oMfJ9wmCuTdNCephJzwYCEL hfl/1iTfhKA0RV98BkQ1qqaGP45wSVMVb+oUWf+Z4JOUn01sedXVh7sPxzjkLmZYY+XK eqIFo7m+90sub3sTbWxNrZp5EScKDFuZxZ3LOvua9g6fj72GkgzXiMAXrKcp6R7dBX/n bEWg== Received: by 10.100.235.40 with SMTP id i40mr2678anh.62.1343426615829; Fri, 27 Jul 2012 15:03:35 -0700 (PDT) Received: from AnibalVAIO (host-1-86.b20.cvc.com.py. [186.2.211.86]) by mx.google.com with ESMTPS id i34sm3133005anm.12.2012.07.27.15.03.32 (version=TLSv1/SSLv3 cipher=OTHER); Fri, 27 Jul 2012 15:03:34 -0700 (PDT) From: "Anibal David Acosta" To: Subject: pgstat wait timeout Date: Fri, 27 Jul 2012 18:03:33 -0400 Message-ID: <001201cd6c43$ac61ed80$0525c880$@devshock.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0013_01CD6C22.255137E0" X-Mailer: Microsoft Outlook 14.0 Thread-Index: Ac1sQmwbNENgV8X+Sb+ZDyeyOqMglQ== Content-Language: es-py X-Gm-Message-State: ALoCoQngS3+ULvHokNlZZNPBtYDjKm+ghdipZ0WvsY0C285Gdv9vK3Tqcejz77x2QYm4RKSq+QOp X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201207/345 X-Sequence-Number: 47526 This is a multipart message in MIME format. ------=_NextPart_000_0013_01CD6C22.255137E0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit In my postgres log I saw a lot of warning like this. WARNING: pgstat wait timeout Every 10 seconds aprox since yesterday and after one year working without any warning I have postgres 9.0.3 on a Windows Server 2008 R2. I have only one big table with aprox. 1,300,000,000 (yes 1,300 millions) rows the table is not used just keep historical record, could be this the reason, some autovacuum over this table? pg_stat_activity not show any autovacuum over this table but yes over the transactional table, right now the autovacuum about transactional table is taking 30 minutes (now() - xact_start ) Thanks ------=_NextPart_000_0013_01CD6C22.255137E0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

In my = postgres log I saw a lot of warning like this…

 

WARNING:  pgstat wait timeout

 

Every 10 = seconds aprox since yesterday and after one year working without any = warning

 

I have postgres 9.0.3 on a Windows Server 2008 = R2.

 

I have only one big table with aprox. 1,300,000,000 = (yes 1,300 millions) rows the table is not used just keep historical = record, could be this the reason, some autovacuum over this = table?

 

pg_stat_activity not show any autovacuum over this = table but yes over the transactional table, right now the autovacuum = about transactional table is taking 30 minutes (now() -  xact_start = )

 

 

Thanks

 

------=_NextPart_000_0013_01CD6C22.255137E0--