Re: [PERFORM] scaling beyond 4 processors

2004-12-10 Thread Josh Berkus
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

Re: [PERFORM] scaling beyond 4 processors

2004-12-06 Thread Christopher Browne
In the last exciting episode, [EMAIL PROTECTED] wrote: > Hello everyone! > > 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. > > So the question is: Has anyone experiences with running Postgres on > systems with

Re: [PERFORM] scaling beyond 4 processors

2004-12-06 Thread Christopher Browne
The perhaps odd thing is that just about any alternative to quad-Xeon is likely to be _way_ better. There are some context switching problems that lead to it being remarkably poorer than you'd expect. Throw in less-than ideal performance of the PAE memory addressing system and it seems oddly cripp

Re: [PERFORM] scaling beyond 4 processors

2004-12-06 Thread Jeff
On Dec 6, 2004, at 5:18 PM, [EMAIL PROTECTED] wrote: Hello everyone! 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. I'm assuming you've already done as much query tweaking as possible. and are you sure you are

[PERFORM] scaling beyond 4 processors

2004-12-06 Thread vogler
Hello everyone! 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. So the question is: Has anyone experiences with running Postgres on systems with more than 4 processors in a production environment? Which syst