X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id ADF68D1B481 for ; Sat, 31 Jan 2004 20:19:23 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 17431-09 for ; Sat, 31 Jan 2004 16:19:18 -0400 (AST) Received: from ganymede.hub.org (u46n208.hfx.eastlink.ca [24.222.46.208]) by svr1.postgresql.org (Postfix) with ESMTP id B81C0D1DA67 for ; Sat, 31 Jan 2004 16:19:16 -0400 (AST) Received: by ganymede.hub.org (Postfix, from userid 1000) id ADDE83515C; Sat, 31 Jan 2004 16:15:35 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id ACDE53515B; Sat, 31 Jan 2004 16:15:35 -0400 (AST) Date: Sat, 31 Jan 2004 16:15:35 -0400 (AST) From: "Marc G. Fournier" X-X-Sender: scrappy@ganymede.hub.org To: Tom Lane Cc: David Teran , Stephan Szabo , PgSQL Performance ML Subject: Re: another query optimization question In-Reply-To: <3875.1075563956@sss.pgh.pa.us> Message-ID: <20040131161128.N63159@ganymede.hub.org> References: <32DEEB93-534E-11D8-9392-000A95A6F0DC@cluster9.com> <20040130100845.E58632@megazone.bigpanda.com> <17545.1075490366@sss.pgh.pa.us> <07461B1A-5370-11D8-9392-000A95A6F0DC@cluster9.com> <20419.1075502429@sss.pgh.pa.us> <39D3D2E6-53D8-11D8-9392-000A95A6F0DC@cluster9.com> <3875.1075563956@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/349 X-Sequence-Number: 5523 On Sat, 31 Jan 2004, Tom Lane wrote: > David Teran writes: > > Apple provides a little tool that can enable / disable the l2 cache ... > > one CPU of a dual CPU system on the fly. When i start the testapp with > > two CPU's enabled i get this output here, when i turn off one CPU while > > the app is still running the messages disappear as long as one CPU is > > turned off. Reactivating the CPU again produces new error messages. > > Ah-hah, so the gettimeofday bug *is* linked to multiple CPUs. Marc, > were the machines you saw it on all multi-CPU? I'm not sure ... I thought I ran it on my P4 here in the office and saw it too, albeit not near as frequently ... but, in FreeBSD's case, it is a "design issue" ... there are two different functions, once that is kinda fuzzy (but fast), and the other that is designed to be exact, but at a performance loss ... or was it the same function, but a 'sysctl' variable that changes the state? Can't remember which, but it is by design on FreeBSD ... and, if we're talking about Apple, the same most likely applies, as its based on the same kernel ... Back of my mind, I *think* it was these sysctl variables: kern.timecounter.method: 0 kern.timecounter.hardware: i8254 ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664