From: Josh Berkus <josh@agliodbs.com>
To: pgsql-performance@postgresql.org
Cc: vogler@cipsoft.com
Subject: Re: scaling beyond 4 processors
Date: Tue, 7 Dec 2004 09:49:20 -0800
Message-ID: <200412070949.20020.josh@agliodbs.com> (raw)
In-Reply-To: <41B4E8B6.6059.1FBEABB@localhost>
References: <41B4E8B6.6059.1FBEABB@localhost>
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
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: josh@agliodbs.com, vogler@cipsoft.com
Subject: Re: scaling beyond 4 processors
In-Reply-To: <200412070949.20020.josh@agliodbs.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