Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 64BB6152A2F9 for ; Fri, 27 Jul 2012 19:31:41 -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 1Sut4K-0001hm-4p for pgsql-performance@postgresql.org; Fri, 27 Jul 2012 22:31:40 +0000 Received: by gglu4 with SMTP id u4so3717008ggl.19 for ; Fri, 27 Jul 2012 15:31:22 -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=FaM/gOeVeOg3F38DRunyojfC2xSnEwT6q9UkpdrSvhI=; b=NLrn4/ml/j7e22F1X/ycOKbk1eJsfeG2Qm6yzjoarQT0dUMuLcxujvjdpFzloqxipV q1mn/hJu8ciGEya60rcW+Qo+3HbEj9DCUahi/TtdnNuXTSmyQfZjx3CgfDo4OY6u8aWY oD40w9ZPDMxPUzsOlQSZZqLneai+gzZLz+iT6RRIEnGnOGA+shNr1EE4g2qFxeYgPo4R ZwHKm/NbOO0Kk2W1s5kxXEKiMVkJXPZ0u9kqYUYt5thV1m8bKj1KH574MOcsAcCyU6+Z 3hWIdrue9KxhCaFLfSc9n0x7Yk9tbMJvg+jKdJ7aL5QyV4tMx2bVtRzSguXERYSVakq2 ZPqA== Received: by 10.236.165.1 with SMTP id d1mr3900696yhl.26.1343428282699; Fri, 27 Jul 2012 15:31:22 -0700 (PDT) Received: from AnibalVAIO (host-1-86.b20.cvc.com.py. [186.2.211.86]) by mx.google.com with ESMTPS id e24sm6293832yhh.4.2012.07.27.15.31.20 (version=TLSv1/SSLv3 cipher=OTHER); Fri, 27 Jul 2012 15:31:21 -0700 (PDT) From: "Anibal David Acosta" To: References: In-Reply-To: Subject: Re: pgstat wait timeout Date: Fri, 27 Jul 2012 18:31:21 -0400 Message-ID: <002001cd6c47$8e3be460$aab3ad20$@devshock.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0021_01CD6C26.072B55D0" X-Mailer: Microsoft Outlook 14.0 Thread-Index: Ac1sQmwbNENgV8X+Sb+ZDyeyOqMglQABL4Uw Content-Language: es-py X-Gm-Message-State: ALoCoQl74InQCAUC1/ZvIRgXBQaWNIsElFwyNy5Af0mBQ3XszVBmFf+OZ9PK2zlnI87GJjxZPnfq X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201207/346 X-Sequence-Number: 47527 This is a multipart message in MIME format. ------=_NextPart_000_0021_01CD6C26.072B55D0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit More information. After many "WARNING: pgstat wait timeout" in the log also appear "ERROR: canceling autovacuum task " De: Anibal David Acosta [mailto:aa@devshock.com] Enviado el: viernes, 27 de julio de 2012 06:04 p.m. Para: pgsql-performance@postgresql.org Asunto: pgstat wait timeout 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_0021_01CD6C26.072B55D0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

More information…

After many = “WARNING: pgstat wait timeout” in the log also appear = “ERROR: canceling autovacuum task = “

De: Anibal = David Acosta [mailto:aa@devshock.com]
Enviado el: viernes, 27 = de julio de 2012 06:04 p.m.
Para: = pgsql-performance@postgresql.org
Asunto: pgstat wait = timeout

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_0021_01CD6C26.072B55D0--