by Anand Chitipothu (@anandology) on Tuesday, 31 March 2015

+10
Vote on this proposal
Status: Confirmed & Scheduled
View session in schedule
Section
Full talk

Technical level
Intermediate

Media

Objective

To provide in-depth comparison of MySQL and PostgreSQL, highligihting the advanced features of PostgreSQL.

Description

MySQL is the most popular database server, but popular doesn’t always mean the best.

PostgreSQL on the other hand is less popupar, but claims to be the most advanced database server.

In this talk I plan to do a in-depth comparision of MySQL and PostgreSQL on various fronts.

Outline:

  • Brief history of MySQL and PostgreSQL
  • MySQL ate my cake - cases where mysql strips data without telling you
  • MySQL vs. PostgreSQL in Database Maintanance
    • creating indexes
    • alter table
    • auto increment issues
  • Exection Model - MySQL threads vs. PostgreSQL processes
  • Replication - How replication works is MySQL and PostgreSQL
  • Advanced Features of PostgreSQL
    • Write Ahead Log and Point In Time Recovery
    • Table partitioning
    • partial indexes
    • JSON type
    • fuzzy string matching
    • views

Speaker bio

I’m an independent software consultant and trainer.

I’ve been using PostgreSQL for long time. During my work at Internet Archive, I’ve migrated their database server from MySQL to PostgreSQL and learnt lot of things about both of them during that.

Comments

Login with Twitter or Google to leave a comment