From owner-freebsd-ports@FreeBSD.ORG Tue Sep 30 14:54:30 2008 Return-Path: Delivered-To: ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 84AE01065699 for ; Tue, 30 Sep 2008 14:54:30 +0000 (UTC) (envelope-from pfandrade@enoughpepper.com) Received: from gv-out-0910.google.com (gv-out-0910.google.com [216.239.58.188]) by mx1.freebsd.org (Postfix) with ESMTP id 2255E8FC27 for ; Tue, 30 Sep 2008 14:54:29 +0000 (UTC) (envelope-from pfandrade@enoughpepper.com) Received: by gv-out-0910.google.com with SMTP id n8so24203gve.39 for ; Tue, 30 Sep 2008 07:54:28 -0700 (PDT) Received: by 10.103.215.4 with SMTP id s4mr4937395muq.13.1222784866776; Tue, 30 Sep 2008 07:27:46 -0700 (PDT) Received: from cidhcp125.ist.utl.pt (cidhcp125.ist.utl.pt [193.136.132.125]) by mx.google.com with ESMTPS id y37sm2239236mug.13.2008.09.30.07.27.44 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 30 Sep 2008 07:27:45 -0700 (PDT) Message-Id: From: "Paulo F. Andrade" To: girgen@FreeBSD.org Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v929.2) Date: Tue, 30 Sep 2008 15:27:42 +0100 X-Mailer: Apple Mail (2.929.2) Cc: ports@FreeBSD.org Subject: FreeBSD Port: postgresql-server-8.3.3 X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 30 Sep 2008 14:54:30 -0000 Hello, I'm contacting to possibly get some directions on solving a problem I'm experiencing with FreeBSD 7 and postgresql-8.3.1. Basically, for time to time postgresql stats collector consumes 100% CPU and does not let go. The same issue has been reported in the following places: http://archives.postgresql.org/pgsql-general/2008-06/msg01026.php http://groups.google.com/group/pgsql.general/browse_thread/thread/6dfea591d243e987 Where should I direct my questions? Thank you for your time. PS: I looked at the changelog for versions 8.3.2 and 8.3.3 but the only mention to the stats collector is this: "Improve ANALYZE's handling of in-doubt tuples (those inserted or deleted by a not-yet-committed transaction) so that the counts it reports to the stats collector are more likely to be correct (Pavan Deolasee)" Paulo F. Andrade pfandrade@enoughpepper.com