From: Jim C. Nasby <decibel@decibel.org>
To: Joel Fradkin <jfradkin@wazagua.com>
Cc: Alvaro Herrera <alvherre@dcc.uchile.cl>
Cc: Andreas Pflug <pgadmin@pse-consulting.de>
Cc: Dave Page <dpage@vale-housing.co.uk>
Cc: pgsql-performance@postgresql.org, ac@wazagua.com, "'Joshua D. Drake'" <jd@commandprompt.com>
Cc: wheyliger@wazagua.com, 'Steve Hatt' <shatt@wazagua.com>
Subject: Re: Joel's Performance Issues WAS : Opteron vs Xeon
Date: Fri, 22 Apr 2005 21:11:07 -0500
Message-ID: <20050423021107.GX58835@decibel.org> (raw)
In-Reply-To: <000001c5477e$da38e3e0$797ba8c0@jfradkin>
References: <20050422183054.GB14419@dcc.uchile.cl>
<000001c5477e$da38e3e0$797ba8c0@jfradkin>
On Fri, Apr 22, 2005 at 05:04:19PM -0400, Joel Fradkin wrote:
> And is the system always going to be used by only one user?
> No we have 400+ concurrent users
>
> I guess the question is if this big select is representative of the load you
> expect in production.
> Yes we see many time on the two processor box running MSSQL large return
> sets using 100%cpu for 5-30 seconds.
>
> What happens if you execute the query more times? Do the times stay the
> same as the second run?
> I will definitely have to pressure testing prior to going live in
> production. I have not done concurrent tests as honestly single user tests
> are failing, so multiple user testing is not something I need yet.
I would very, very strongly encourage you to run multi-user tests before
deciding on mysql. Mysql is nowhere near as capable when it comes to
concurrent operations as PostgreSQL is. From what others have said, it
doesn't take many concurrent operations for it to just fall over. I
can't speak from experience because I avoid mysql like the plague,
though. :)
Likewise, MSSQL will probably look better single-user than it will
multi-user. Unless you're going to only access the database single-user,
it's just not a valid test case (and by the way, this is true no matter
what database you're looking at. Multiuser access is where you uncover
your real bottlenecks.)
--
Jim C. Nasby, Database Consultant decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
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: decibel@decibel.org, jfradkin@wazagua.com, alvherre@dcc.uchile.cl, pgadmin@pse-consulting.de, dpage@vale-housing.co.uk, jd@commandprompt.com, shatt@wazagua.com
Subject: Re: Joel's Performance Issues WAS : Opteron vs Xeon
In-Reply-To: <20050423021107.GX58835@decibel.org>
* 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