From: Joel Fradkin <jfradkin@wazagua.com>
To: 'Jim C. Nasby' <decibel@decibel.org>
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
Cc: ac@wazagua.com
Cc: 'Joshua D. Drake' <jd@commandprompt.com>
Cc: wheyliger@wazagua.com
Cc: 'Steve Hatt' <shatt@wazagua.com>
Subject: Re: Joel's Performance Issues WAS : Opteron vs Xeon
Date: Sat, 23 Apr 2005 10:11:28 -0400
Message-ID: <001701c5480e$57e7fad0$797ba8c0@jfradkin> (raw)
In-Reply-To: <20050423021107.GX58835@decibel.org>
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. :)
I am just testing the water so to speak, if it cant handle single user tests
then multiple user tests are kind of a waste of time.
I am trying to de-normalize my view into a table to see if I can get my app
to work. It is a good idea anyway but raises a ton of questions about
dealing with the data post a case being closed etc; also on multiple child
relationships like merchandise and payments etc.
I did do a test of all three (MSSQL, MYSQL,and postgres) in aqua studio ,
all on the same machine running the servers and found postgres beat out
MYSQL, but like any other test it may have been an issue with aqua studio
and mysql in any case I have not made a decision to use mysql I am still
researching fixes for postgres.
I am waiting to here back from Josh on using cursors and trying to flatten
long running views.
I am a little disappointed I have not understood enough to get my analyzer
to use the proper plan, we had to set seqscan off to get the select from
response_line to work fast and I had to turn off merge joins to get assoc
list to work fast. Once I am up I can try to learn more about it, I am so
glad there are so many folks here willing to take time to educate us newb's.
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: jfradkin@wazagua.com, decibel@decibel.org, alvherre@dcc.uchile.cl, pgadmin@pse-consulting.de, dpage@vale-housing.co.uk, ac@wazagua.com, jd@commandprompt.com, wheyliger@wazagua.com, shatt@wazagua.com
Subject: Re: Joel's Performance Issues WAS : Opteron vs Xeon
In-Reply-To: <001701c5480e$57e7fad0$797ba8c0@jfradkin>
* 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