From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jeff Trout <threshar@torgo.978.org>
Cc: postgres performance <pgsql-performance@postgresql.org>
Subject: Re: OSX & Performance
Date: Sun, 28 Aug 2005 16:00:49 -0400
Message-ID: <26476.1125259249@sss.pgh.pa.us> (raw)
In-Reply-To: <C5CA67B2-E8DC-414D-B298-A9292323F26E@torgo.978.org>
References: <C5CA67B2-E8DC-414D-B298-A9292323F26E@torgo.978.org>
Jeff Trout <threshar@torgo.978.org> writes:
> Tracking ti down a bit timestamp_cmp_internal (The btree was made of
> a timestamp & and int) was taking a large amount of time -
> specifically all the calls it makes to isnan(x). 14.1% in __isnand
Hmm, can you provide a test case for other people to poke at?
> Also, two things to note, one of which is quite important: On tiger
> (10.4) PG compiles with NO OPTIMIZATION. Probably a template file
> needs to be updated.
> Panther seems to compile with -O2 though.
I see -O2 when building PG (CVS tip) on a fully up-to-date 10.4.2
machine. Maybe something odd in your environment, like a preset
CFLAGS setting?
regards, tom lane
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, threshar@torgo.978.org
Subject: Re: OSX & Performance
In-Reply-To: <26476.1125259249@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