On Tue, Oct 26, 2010 at 6:55 AM, Christian Elmerot <ce@one.com> wrote:
> 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)?
For faster but fewer individual cores the Intels are pretty good. For
way more cores, each being pretty fast and having enough memory
bandwidth to use all those cores, the AMDs are very impressive. The
Magny Cours AMDs are probably the best 4 socket cpus made.
> 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.
A single AMD 12 core Magny Cours or Intel Nehalem 8 core cpu would be
twice as fast or more than the old machine.
> 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).
As another poster mentioned, you should really look at connection pooling.