From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Jeff Trout <threshar(at)torgo(dot)978(dot)org> |
Cc: | postgres performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: OSX & Performance |
Date: | 2005-08-28 20:00:49 |
Message-ID: | 26476.1125259249@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Jeff Trout <threshar(at)torgo(dot)978(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Ilia Kantor | 2005-08-28 20:41:18 | intarray is broken ? (8.1b1) |
Previous Message | Arjen van der Meijden | 2005-08-28 14:44:37 | Re: Inefficient queryplan for query with intersectable |