Re: OSX & Performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: OSX & Performance
Date
Msg-id 26476.1125259249@sss.pgh.pa.us
Whole thread Raw
In response to OSX & Performance  (Jeff Trout <threshar@torgo.978.org>)
Responses Re: OSX & Performance
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Arjen van der Meijden
Date:
Subject: Re: Inefficient queryplan for query with intersectable
Next
From: "Ilia Kantor"
Date:
Subject: intarray is broken ? (8.1b1)