System News
Millions of Queries per Second: PostgreSQL and MySQL's Peaceful Battle at Today's Demanding Workloads
Percona, January 6th, 2017
January 6, 2017,
Volume 227, Issue 1

Anastasia Raspopina and Sveta Smirnova blogs, "This blog compares how PostgreSQL and MySQL handle millions of queries per second.

Anastasia: Can open source databases cope with millions of queries per second? Many open source advocates would answer 'yes.' However, assertions aren't enough for well-grounded proof. That's why in this blog post, we share the benchmark testing results from Alexander Korotkov (CEO of Development, Postgres Professional) and Sveta Smirnova (Principal Technical Services Engineer, Percona). The comparative research of PostgreSQL 9.6 and MySQL 5.7 performance will be especially valuable for environments with multiple databases.

The idea behind this research is to provide an honest comparison for the two popular RDBMSs. Sveta and Aleksander wanted to test the most recent versions of both MySQL and PostgreSQL with the same tool, under the same challenging workloads and using the same configuration parameters (where possible). However, because both PostgreSQL and MySQL ecosystems evolved independently, with standard testing tools (pgbench and SysBench) used for each database, it wasn't an easy journey..."

Read More ... [...read more...]

Keywords:

 

Other articles in the Performance section of Volume 227, Issue 1:
  • Millions of Queries per Second: PostgreSQL and MySQL's Peaceful Battle at Today's Demanding Workloads (this article)

See all archived articles in the Performance section.

Trending in
Vol 233, Issue 3
Trending IT Articles