X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 1CA2911F66CA for ; Wed, 5 Apr 2006 19:01:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 14626-06 for ; Wed, 5 Apr 2006 19:01:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 12D0E11F6621 for ; Wed, 5 Apr 2006 19:01:29 -0300 (ADT) Received: from [10.180.0.159] (unknown [66.228.91.67]) (using TLSv1 with cipher RC4-SHA (128/128 bits)) (No client certificate requested) by noel.decibel.org (Postfix) with ESMTP id 920E856427; Wed, 5 Apr 2006 17:01:28 -0500 (CDT) In-Reply-To: <13170.1144128543@sss.pgh.pa.us> References: <22874.1143340808@sss.pgh.pa.us> <443109B6.EE98.0025.0@wicourts.gov><443109B6.EE98.0025.0@wicourts.gov> <14779.1144083156@sss.pgh.pa.us> <44316221.EE98.0025.0@wicourts.gov> <13170.1144128543@sss.pgh.pa.us> Mime-Version: 1.0 (Apple Message framework v746.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <9B051C17-D2AA-4775-853E-9A055BC2E208@pervasive.com> Cc: "Kevin Grittner" , "Jerry Sievers" , pgsql-admin@postgresql.org, "Peter Brant" Content-Transfer-Encoding: 7bit From: Jim Nasby Subject: Re: pg_stat_activity showing non-existent processes Date: Wed, 5 Apr 2006 17:59:40 -0400 To: Tom Lane X-Mailer: Apple Mail (2.746.3) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.493 required=5 tests=[AWL=0.493] X-Spam-Score: 0.493 X-Spam-Level: X-Archive-Number: 200604/61 X-Sequence-Number: 21230 On Apr 4, 2006, at 1:29 AM, Tom Lane wrote: > "Kevin Grittner" writes: >> It is probably related to something we've been seeing in the >> PostgreSQL >> logs on the Windows servers: > >> [2006-04-03 08:28:25.990 ] 2072 FATAL: could not read from >> statistics >> collector pipe: No error >> [2006-04-03 08:28:26.068 ] 2012 LOG: statistics collector process >> (PID >> 3268) was terminated by signal 1 > > We've heard reports of instability in the stats collector on Windows > before, though I'm not sure if this is exactly the symptom --- check > the list archives. Nobody's been able to track it down yet. BTW, I was (attempting) to do some performance testing on windows Sunday with pgbench and I was getting an error similar to that (sorry for being so vague, but I'm ~2000 miles from that server right now). This was on a database created with a scale factor of 40 running on a dual Xeon with plain SCSI drives (base tables on a seperate drive from pg_xlog) running on XP with SP1. Any attempt to run pgbench with 40 connections for more than about 50 transactions would result in that error (as well as some other ugliness). Based just on that limited experience it looks like the windows port could use a lot more shaking out with pgbench. Perhaps it would be a good idea to add pgbench to the buildfarm test. -- Jim C. Nasby, Database Architect decibel@decibel.org Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461