Re: AMD or Intel?

On Sep 13, 2007, at 3:24 PM, Palle Girgensohn wrote:
--On torsdag, torsdag 13 sep 2007 15.07.17 -0400 Francisco Reyes <lists@xxxxxxxxxxxxxxxx> wrote:

Palle Girgensohn writes:

Now, I hear rumors that AMD is to be preferred over Intel for
performance

From what I have read in the past, specially in the postgresql list, it
seems the AMD64 cpus do better with Postgresql. Possibly because of
better bus architecture.

I think this is not current information; the new woodcrest architecture performs mucg better, although this is deduced from this thread's discussion...

Except this thread has largely glossed over the importance of memory bandwidth, which is exactly the reason why Opterons have been beating Xeons for several years. Last I'd heard, things were fairly close between the two, but that would matter on how many cores and physical CPUs you have.

It would be good if someone could do a database benchmark for some of the larger parts.

Something else worth mentioning... a lot of work is being done to improve PostgreSQL scalability for larger numbers of CPUs. If you're looking at anything over 4 cores, I recommend going to 8.3 ASAP.
--
Decibel!, aka Jim C. Nasby, Database Architect decibel@xxxxxxxxxxx
Give your computer some brain candy! www.distributed.net Team #1828


_______________________________________________
freebsd-performance@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to "freebsd-performance-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • Re: AMD or Intel?
    ... architecture performs mucg better, although this is deduced from this thread's discussion... ... Last I'd heard, things were fairly close between the two, but that would matter on how many cores and physical CPUs you have. ... a lot of work is being done to improve PostgreSQL scalability for larger numbers of CPUs. ...
    (freebsd-performance)
  • [SECURITY] [DSA 165-1] New PostgreSQL packages fix several vulnerabilities
    ... Mordred Labs and others found several vulnerabilities in PostgreSQL, ... buffer overflows and integer overflows. ... Debian ships in the potato release since the corresponding ... Architecture independent components: ...
    (Bugtraq)
  • [Full-Disclosure] [SECURITY] [DSA 165-1] New PostgreSQL packages fix several vulnerabilities
    ... Mordred Labs and others found several vulnerabilities in PostgreSQL, ... buffer overflows and integer overflows. ... Debian ships in the potato release since the corresponding ... Architecture independent components: ...
    (Full-Disclosure)
  • Re: [PHP] Re: Getting last record ID created from DB
    ... architecture of your methodology *only* works with MySQL, ... They use PostgreSQL and we do have a auto incremented unique id ... In theory that may be true, but can the application developer make any ... I suck at PHP, I do know PHP, I've written a ...
    (php.general)
  • [SECURITY] [DSA 516-1] New odbc-postgresql packages fix denial of service
    ... A buffer overflow has been discovered in the ODBC driver of PostgreSQL, ... If you are using the apt-get package manager, ... Debian GNU/Linux 3.0 alias woody ... Architecture independent components: ...
    (Bugtraq)