Re: New to PostgreSQL, performance considerations

Поиск
Список
Период
Сортировка
От Alexander Staubo
Тема Re: New to PostgreSQL, performance considerations
Дата
Msg-id BCA64E3D-E764-432B-82CB-C2FC75CF3104@purefiction.net
обсуждение исходный текст
Ответ на Re: New to PostgreSQL, performance considerations  (Ron <rjpeace@earthlink.net>)
Ответы Re: New to PostgreSQL, performance considerations  (Ron <rjpeace@earthlink.net>)
Re: New to PostgreSQL, performance considerations  (Greg Smith <gsmith@gregsmith.com>)
Список pgsql-performance
On Dec 14, 2006, at 20:28 , Ron wrote:

> Can you do runs with just CFLAGS="-O3" and just CFLAGS="-msse2 -
> mfpmath=sse -funroll-loops -m64 - march=opteron -pipe" as well ?

All right. From my perspective, the effect of -O3 is significant,
whereas architecture-related optimizations have no statistically
significant effect. As far as I'm aware, though, there's no other
arch targets on the Opteron that will make sense, there being no
predecessor CPU instruction set to choose from; -march=pentium4
doesn't exist.

> Also, what HDs are you using?  How many in what config?

I believe the volume is a two-drive RAID 1 configuration, but I'm not
managing these servers, so I'll ask the company's support people.

Interestingly enough I see that PostgreSQL seems to be writing around
1MB/s during the pgbench run, even though I'm running pgbench in the -
S mode. I haven't had the chance to look at the source yet; is it
really only doing selects?

Alexander.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Insertion to temp table deteriorating over time
Следующее
От: "Kelly Burkhart"
Дата:
Сообщение: Re: EXPLAIN ANALYZE on 8.2