From: PFC <lists@peufeu.com>
To: Scott Marlowe <smarlowe@g2switchworks.com>
Cc: Marcos <mjs_ops@gmx.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Decide between Postgresql and Mysql (help of
Date: Tue, 28 Mar 2006 23:24:28 +0200
Message-ID: <op.s64622kgcigqcu@apollo13> (raw)
In-Reply-To: <1143575445.3625.87.camel@state.g2switchworks.com>
References: <1143559902.1241.16.camel@servidor>
<1143572392.3625.79.camel@state.g2switchworks.com>
<op.s642dpyecigqcu@apollo13>
<1143575445.3625.87.camel@state.g2switchworks.com>
> What really makes innodb useless to me is that there's no real support
> for proper operation by MySQL itself. If you could force MySQL to only
> use innodb tables, and to NEVER do the wrong things syntactically, it
> would be ok. But there are thousands of foot-guns in the MySQL
That's what I meant actually.
And by saying "if you want transactions" I also meant "if you want a
database system that will go to great lengths to save your ass and your
data instead of helping you shooting yourself in the foot, generally work
very well, be reliable, friendly and a pleasure to work with, which means
more or less, if you're rational rather than masochistic, then yeah, you
should use postgres".
> If you could force MySQL to only
> use innodb tables, and to NEVER do the wrong things syntactically, it
> would be ok.
You'd still need to teach it how to hash-join and everything, though.
Life sucks when the only join type you have is merge join.
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: lists@peufeu.com, smarlowe@g2switchworks.com, mjs_ops@gmx.net
Subject: Re: Decide between Postgresql and Mysql (help of
In-Reply-To: <op.s64622kgcigqcu@apollo13>
* 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