Re: Decide between Postgresql and Mysql (help of

From: PFC
Subject: Re: Decide between Postgresql and Mysql (help of
Date: ,
Msg-id: op.s64622kgcigqcu@apollo13
(view: Whole thread, Raw)
In response to: Re: Decide between Postgresql and Mysql (help of  (Scott Marlowe)
List: pgsql-performance

Tree view

Decide between Postgresql and Mysql (help of comunity)  (Marcos, )
 Re: Decide between Postgresql and Mysql (help of comunity)  (Madison Kelly, )
  Re: Decide between Postgresql and Mysql (help of comunity)  (Vivek Khera, )
 Re: Decide between Postgresql and Mysql (help of  (Scott Marlowe, )
  Re: Decide between Postgresql and Mysql (help of  (Marcos, )
   Re: Decide between Postgresql and Mysql (help of  (Chris Travers, )
   Re: Decide between Postgresql and Mysql (help of  (PFC, )
   Re: Decide between Postgresql and Mysql (help of  (Vivek Khera, )
  Re: Decide between Postgresql and Mysql (help of  (PFC, )
   Re: Decide between Postgresql and Mysql (help of  ("Jim C. Nasby", )
   Re: Decide between Postgresql and Mysql (help of  ("Jim C. Nasby", )
    Re: Decide between Postgresql and Mysql (help of  ("Merlin Moncure", )
  Re: Decide between Postgresql and Mysql (help of  (Vivek Khera, )
 Re: Decide between Postgresql and Mysql (help of  (Scott Marlowe, )
  Re: Decide between Postgresql and Mysql (help of  (PFC, )
  Re: Decide between Postgresql and Mysql (help of  (Gorshkov, )
   Re: Decide between Postgresql and Mysql (help of  ("Craig A. James", )
    Re: Decide between Postgresql and Mysql (help of  (Gorshkov, )
     Re: Decide between Postgresql and Mysql (help of  ("Craig A. James", )
      Re: Decide between Postgresql and Mysql (help of  (Gorshkov, )
    Re: Decide between Postgresql and Mysql (help of  (Markus Schaber, )
 Re: Decide between Postgresql and Mysql (help of  (Chris Browne, )
  Re: Decide between Postgresql and Mysql (help of  (Scott Marlowe, )
   Re: Decide between Postgresql and Mysql (help of  (PFC, )
    Re: Decide between Postgresql and Mysql (help of  ("Steinar H. Gunderson", )
     Re: Decide between Postgresql and Mysql (help of  (Philippe Marzin, )
    Re: Decide between Postgresql and Mysql (help of  (Guido Neitzer, )
 Re: Decide between Postgresql and Mysql (help of  (Chris Browne, )

> 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.


pgsql-performance by date:

From: "Dave Dutcher"
Date:
Subject: Re: simple join uses indexes, very slow
From: "Qingqing Zhou"
Date:
Subject: Re: MVCC intro and benefits docs?