Re: OSX & Performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: OSX & Performance
Дата
Msg-id 26476.1125259249@sss.pgh.pa.us
обсуждение исходный текст
Ответ на OSX & Performance  (Jeff Trout <threshar@torgo.978.org>)
Ответы Re: OSX & Performance
Список 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 по дате отправления:

Предыдущее
От: Arjen van der Meijden
Дата:
Сообщение: Re: Inefficient queryplan for query with intersectable
Следующее
От: "Ilia Kantor"
Дата:
Сообщение: intarray is broken ? (8.1b1)