From: Christian Elmerot @ One.com <ce@one.com>
To: pgsql-performance@postgresql.org
Subject: CPUs for new databases
Date: Mon, 25 Oct 2010 11:53:17 +0200
Message-ID: <4CC5538D.8090806@one.com> (raw)
Hello,
What is the general view of performance CPU's nowadays when it comes to
PostgreSQL performance? Which CPU is the better choice, in regards to
RAM access-times, stream speed, cache synchronization etc. Which is the
better CPU given the limitation of using AMD64 (x86-64)?
We're getting ready to replace our (now) aging db servers with some
brand new with higher core count. The old ones are 4-socket dual-core
Opteron 8218's with 48GB RAM. Right now the disk-subsystem is not the
limiting factor so we're aiming for higher core-count and as well as
faster and more RAM. We're also moving into the territory of version 9.0
with streaming replication to be able to offload at least a part of the
read-only queries to the slave database. The connection count on the
database usually lies in the region of ~2500 connections and the
database is small enough that it can be kept entirely in RAM (dump is
about 2,5GB).
Regards,
Christian Elmerot
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ce@one.com
Subject: Re: CPUs for new databases
In-Reply-To: <4CC5538D.8090806@one.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox