Skip site navigation (1) Skip section navigation (2)

Re: scaling beyond 4 processors

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: vogler(at)cipsoft(dot)com
Subject: Re: scaling beyond 4 processors
Date: 2004-12-07 17:49:20
Message-ID: 200412070949.20020.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Volger,

> Since our current Postgres server, a quad Xeon system, finally can't keep
> up with our load anymore we're ready to take the next step.

There are a lot of reasons this could be happening; Quad Xeon is a problematic 
platform, the more so if you're on Dell hardware.

I've run PostgreSQL on 8-ways, and I know there are a few Sunfire users around 
the community (16-way).   There are definitely specific performance issues 
around specific query loads on multi-way systems; search this list archives 
for "Context Switch Bug".

I will echo others in saying that moving to Opteron on premium hardware should 
jump you at least 2x on performance, and it's a lot cheaper than DB2 or 
Oracle.

And, of course, if you really want help from this list, you'll post more 
specific problems.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

pgsql-performance by date

Next:From: Joshua D. DrakeDate: 2004-12-07 18:35:03
Subject: Re: Fwd: 8.0 vs. 7.4 benchmarks
Previous:From: Bruno Wolff IIIDate: 2004-12-07 17:43:55
Subject: Re: Fwd: 8.0 vs. 7.4 benchmarks

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group