Query Optimizer - MySQL vs. PostgreSQL

Wednesday 3:20 PM - 4:10 PM

@ Nikkei

PostgreSQLMySQL/MariaDB

50 minutes conference

Advanced

Tracks:
Operations

MySQL and PostgreSQL are the two most popular open-source relational databases. To help to choose between them, a comparison of their query optimizers has been carried out. The aim of this session is to summarize the outcome of the comparison. Specifically, to point out optimizer-related strengths and weaknesses.


Speakers

Christian Antognini

Christian Antognini (Trivadis)

Senior Principal Consultant

Biography:

Christian Antognini is a strong believer that at the core it is all about the data, and on how effectively companies process and take advantage of it. For that reason, since 1995 he has focused on the efficient use of database engines. His main interests include logical and physical database design, query optimizers, and basically everything else related to data processing and application performance management. He is currently working as a senior principal consultant and trainer at Trivadis in Zürich, Switzerland.
If Christian is not helping one of his customers get the most out of databases, he is somewhere lecturing on APM or database performance features. In addition to classes and seminars organized by Trivadis, since 2001 he has presented at 100+ conferences and user-group meetings in two dozen countries. He is a proud member of the OakTable Network and is an Oracle ACE Director. Christian is the author of Troubleshooting Oracle Performance (Apress, 2008/2014).


Slides



  Download Slides  

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA