Re: Need help to decide Mysql vs Postgres

От: Joel Fradkin
Тема: Re: Need help to decide Mysql vs Postgres
Дата: ,
Msg-id: 005901c554bc$cff3bf90$797ba8c0@jfradkin
(см: обсуждение, исходный текст)
Ответ на: Re: Need help to decide Mysql vs Postgres  (Amit V Shah)
Список: pgsql-performance

Скрыть дерево обсуждения

Need help to decide Mysql vs Postgres  (Amit V Shah, )
 Re: Need help to decide Mysql vs Postgres  ("Joshua D. Drake", )
 Re: Need help to decide Mysql vs Postgres  (Amit V Shah, )
  Re: Need help to decide Mysql vs Postgres  ("Joel Fradkin", )
  Re: Need help to decide Mysql vs Postgres  ("Joshua D. Drake", )
   Re: Need help to decide Mysql vs Postgres  (Philip Hallstrom, )
 Re: Need help to decide Mysql vs Postgres  (Josh Berkus, )
 Re: Need help to decide Mysql vs Postgres  (Amit V Shah, )
  Re: Need help to decide Mysql vs Postgres  ("Steinar H. Gunderson", )
  Re: Need help to decide Mysql vs Postgres  (Josh Berkus, )
 Re: Need help to decide Mysql vs Postgres  (PFC, )
 Re: Need help to decide Mysql vs Postgres  ( (), )
 Re: Need help to decide Mysql vs Postgres  (Bill Ewing, )
  Re: Need help to decide Mysql vs Postgres  (Christopher Kings-Lynne, )
  Re: Need help to decide Mysql vs Postgres  (PFC, )
 Re: Need help to decide Mysql vs Postgres  (Jeffrey Tenny, )
  Re: Need help to decide Mysql vs Postgres  (Tobias Brox, )
   Re: Need help to decide Mysql vs Postgres  (Michael Fuhr, )
 Re: Need help to decide Mysql vs Postgres  (Amit V Shah, )
  Re: Need help to decide Mysql vs Postgres  (Alvaro Herrera, )
  Re: Need help to decide Mysql vs Postgres  (Rod Taylor, )
  Re: Need help to decide Mysql vs Postgres  (PFC, )
 Re: Need help to decide Mysql vs Postgres  (Amit V Shah, )
  Re: Need help to decide Mysql vs Postgres  (Christopher Browne, )
   Re: Need help to decide Mysql vs Postgres  (Ron Mayer, )
    Re: Need help to decide Mysql vs Postgres  (Tom Lane, )
  Re: Need help to decide Mysql vs Postgres  (PFC, )
   Re: Need help to decide Mysql vs Postgres  (Jan Wieck, )
    Re: Need help to decide Mysql vs Postgres  ("Joel Fradkin", )
     Re: Need help to decide Mysql vs Postgres  (PFC, )
      Re: Need help to decide Mysql vs Postgres  (Enrico Weigelt, )
       Re: Need help to decide Mysql vs Postgres  (Mark Lewis, )
        Re: Need help to decide Mysql vs Postgres  (Moises Alberto Lindo Gutarra, )

I took an unbiased look and did some tests.
Objectively for me MYSQL was not an improvement for speed.
I had read the benchmarks in pcmagazine from a while back as well.

I did some tests using ODBC, and .net connections and also used aqua studios
(hooks up to both data bases) and found postgres a bit faster.

I did spend more time getting a feeling for setup on postgres, but I was at
a point of desperation as some queries were still too slow on postgres.

I ended up re-engineering my app to use simpler(flattened) data sets.
I still have a few I am working through, but all in all it is running better
then when I was on MSSQL, and MYSQL was just slower on the tests I did.

I loaded both MYSQL and postgres on both my 4 processor Dell running red hat
AS3 and Windows XP on a optiplex.

Joel Fradkin

Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel.  941-753-7111 ext 305


www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
 This email message is for the use of the intended recipient(s) and may
contain confidential and privileged information.  Any unauthorized review,
use, disclosure or distribution is prohibited.  If you are not the intended
recipient, please contact the sender by reply email and delete and destroy
all copies of the original message, including attachments.




-----Original Message-----
From: 
[mailto:] On Behalf Of Amit V Shah
Sent: Tuesday, May 24, 2005 12:22 PM
To: 'Joshua D. Drake'
Cc: ''
Subject: Re: [PERFORM] Need help to decide Mysql vs Postgres

Hi Josh,

Thanks for the prompt reply !! Actually migration is inevitable. We have a
totally messed up schema, not normalized and stuff like that. So the goal of
the migration is to get a new and better normalized schema. That part is
done already. Now the decision point is, should we go with postgres or
mysql.

Thanks,
Amit

-----Original Message-----
From: Joshua D. Drake [mailto:]
Sent: Tuesday, May 24, 2005 1:15 PM
To: Amit V Shah
Cc: ''
Subject: Re: [PERFORM] Need help to decide Mysql vs Postgres


>
> I am not trying to start a mysql vs postgres war so please dont
> misunderstand me .... I tried to look around for mysql vs postgres
articles,
> but most of them said mysql is better in speed. However those articles
were
> very old so I dont know about recent stage. Please comment !!!

It is my experience that MySQL is faster under smaller load scenarios.
Say 5 - 10 connections only doing simple SELECTS. E.g; a dymanic website.

It is also my experience that PostgreSQL is faster and more stable under
consistent and heavy load. I have customers you regularly are using up
to 500 connections.

Note that alot of this depends on how your database is designed. Foreign
keys slow things down.

I think it would be important for you to look at your overall goal of
migration. MySQL is really not a bad product "IF" you are willing to
work within its limitations.

PostgreSQL is a real RDMS, it is like Oracle or DB2 and comes with a
comparable feature set. Only you can decide if that is what you need.

Sincerely,

Joshua D. Drake
Command Prompt, Inc.


--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org



В списке pgsql-performance по дате сообщения:

От: Alex Turner
Дата:
Сообщение: Re: Select performance vs. mssql
От: Josh Berkus
Дата:
Сообщение: Re: Select performance vs. mssql