pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Teran <david.teran@cluster9.com>
Cc: Stephan Szabo <sszabo@megazone.bigpanda.com>
Cc: Marc Fournier <scrappy@hub.org>
Cc: PgSQL Performance ML <pgsql-performance@postgresql.org>
Subject: Re: another query optimization question
Date: Sat, 31 Jan 2004 10:45:56 -0500
Message-ID: <3875.1075563956@sss.pgh.pa.us> (raw)
In-Reply-To: <39D3D2E6-53D8-11D8-9392-000A95A6F0DC@cluster9.com>
References: <32DEEB93-534E-11D8-9392-000A95A6F0DC@cluster9.com>
	<20040130100845.E58632@megazone.bigpanda.com>
	<F8B3002A-5350-11D8-9392-000A95A6F0DC@cluster9.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>

David Teran <david.teran@cluster9.com> 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?

> Do you remember where one can find a patch?

File a bug report with Apple.

> Do you know if this bug makes a system unusable with PostgresSQL?

Not at all.  The only bad effect we've noted is that EXPLAIN results
are sometimes wacky.  In theory you could sometimes see the result of
now() being off by a second or two, but no one's reported seeing that.

			regards, tom lane



view thread (12+ messages)  latest in thread

Message-ID: <3875.1075563956@sss.pgh.pa.us>
Permalink:  ../3875.1075563956@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/3875.1075563956@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, david.teran@cluster9.com, sszabo@megazone.bigpanda.com, scrappy@hub.org
  Subject: Re: another query optimization question
  In-Reply-To: <3875.1075563956@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox