Re: New to PostgreSQL, performance considerations

Поиск
Список
Период
Сортировка
От Florian Weimer
Тема Re: New to PostgreSQL, performance considerations
Дата
Msg-id 82psapuos8.fsf@mid.bfk.de
обсуждение исходный текст
Ответ на Re: New to PostgreSQL, performance considerations  (Cosimo Streppone <cosimo@streppone.it>)
Ответы Re: New to PostgreSQL, performance considerations  ("Daniel van Ham Colchete" <daniel.colchete@gmail.com>)
Список pgsql-performance
* Cosimo Streppone:

> "-O0" ~ 957 tps
> "-O1 -mcpu=pentium4 -mtune=pentium4" ~ 1186 tps
> "-O2 -mcpu=pentium4 -mtune=pentium4" ~ 1229 tps
> "-O3 -mcpu=pentium4 -mtune=pentium4" ~ 1257 tps
> "-O6 -mcpu=pentium4 -mtune=pentium4" ~ 1254 tps

-mcpu and -mtune are synonymous.  You really should -march here (but
the result is non-generic code).  Keep in mind that GCC does not
contain an instruction scheduler for the Pentium 4s.  I also believe
that the GCC switches are not fine-grained enough to cover the various
Pentium 4 variants.  For instance, some chips don't like the CMOV
instruction at all, but others can process it with decent speed.

--
Florian Weimer                <fweimer@bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstraße 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99

В списке pgsql-performance по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: New to PostgreSQL, performance considerations
Следующее
От: Bill Moran
Дата:
Сообщение: Re: New to PostgreSQL, performance considerations