[lug] MySQL vs PostgreSQL

Matt Dew marcoz at osource.org
Fri Aug 3 20:30:22 MDT 2012


If you want some serious information,  contact Kevin Kempter at 
Consistent State.   They do database consulting and are located down 
near the tech center, very heavy on the Postgres, Kevin's specialty is 
data warehousing.   He can give you gory, gory details.  (Disclosure: I 
used to work for him.)  Postgres is used a lot of places, you just don't 
hear about it.

MySQL is good at raw speed.  Postgres is good for more enterprisy things 
like failover, tunability, and getting into the guts to see what's 
really going on under the covers.

kevin at consistentstate.com


Hope that's helpful,
Matt



On 08/03/2012 06:00 PM, Dan Ferris wrote:
> MySQL is very loosy goosey with your data by default.
>
> Here is a comparison that shows how MySQL behaves vs. Postgres.  I think
> you can make MySQL much stricter, but you would not want to use the
> default settings anywhere you cared about data integrity.
>
> http://wekeroad.com/2012/07/19/postgresql-rising
>
> The downside of Postgres is that it's not easy.  I have been dealing
> with it for 2 years and I still suck at it. :)
>
> Dan
>
> On 8/3/2012 4:44 PM, Gordon Golding wrote:
>> Somebody has a PostgreSQL system.
>> They want to do an entire new large data warehouse.
>> I used to work with Postgres, now with MySQL.
>> It seems I just don't see Postgres mentioned that much any more.
>> Would it be best to build the new data warehouse on MySQL?
>> Any comments on one over the other?
>>
>> Gordon
>>
>>
>> _______________________________________________
>> Web Page:http://lug.boulder.co.us
>> Mailing List:http://lists.lug.boulder.co.us/mailman/listinfo/lug
>> Join us on IRC: irc.hackingsociety.org port=6667 channel=#hackingsociety
>
>
>
> _______________________________________________
> Web Page:  http://lug.boulder.co.us
> Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug
> Join us on IRC: irc.hackingsociety.org port=6667 channel=#hackingsociety
>




More information about the LUG mailing list