| 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: | Whole Thread | Raw Message | 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 |