Re: New to PostgreSQL, performance considerations

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: New to PostgreSQL, performance considerations
Дата
Msg-id Pine.GSO.4.64.0612120118340.10640@westnet.com
обсуждение исходный текст
Ответ на Re: New to PostgreSQL, performance considerations  (Michael Stone <mstone+postgres@mathom.us>)
Ответы Re: New to PostgreSQL, performance considerations  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: New to PostgreSQL, performance considerations  (Michael Stone <mstone+postgres@mathom.us>)
Re: New to PostgreSQL, performance considerations  (Ron <rjpeace@earthlink.net>)
Список pgsql-performance
On Mon, 11 Dec 2006, Michael Stone wrote:

> Can anyone else reproduce these results? I'm on similar hardware (2.5GHz P4,
> 1.5G RAM)...

There are two likely candidates for why Daniel's P4 3.0GHz significantly
outperforms your 2.5GHz system.

1) Most 2.5GHZ P4 processors use a 533MHz front-side bus (FSB); most
3.0GHZ ones use an 800MHz bus.

2) A typical motherboard paired with a 2.5GHz era processor will have a
single-channel memory interface; a typical 3.0GHZ era board supports
dual-channel DDR.

These changes could easily explain the magnitude of difference in results
you're seeing, expecially when combined with a 20% greater raw CPU clock.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

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

Предыдущее
От: Christopher Browne
Дата:
Сообщение: Re: New to PostgreSQL, performance considerations
Следующее
От: Tom Lane
Дата:
Сообщение: Re: New to PostgreSQL, performance considerations