CPU types and queries...

Поиск
Список
Период
Сортировка
От James Kelty
Тема CPU types and queries...
Дата
Msg-id 1022702848.22447.4.camel@hamadryad
обсуждение исходный текст
Список pgsql-novice
Hello,

A question was recently brought up at my place of business about CPU
types, and Postgres.

We have Two systems, both running Red Hat 7.2, both with 4Gig's of PC133
memory.

The first system has TWO 933Mhz Intel PIII (Coppermine) procs, and a
certain query returns VERY fast, around 2 seconds.

The second system has TWO 700Mhx Intel PIII Xeon (Cascades) procs, but
the same query from the same code from the same web server takes approx.
10-12 seconds.

Is there REALLY that much difference between the two proc types? Will
233Mhz actually make THAT much of a difference?

What about the big Xeon cache? 1Mb vs. the Coppermine 256k cache?


Thanks for any info!

-James




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

Предыдущее
От: Tim Wilson
Дата:
Сообщение: deleted table remnants
Следующее
От: "nimeshb"
Дата:
Сообщение: ecpg not found