Tags: Performance
Modern Hardware for Future Databases
November 20, 2024 in Database
A survey on how hardware developments affect database design, covering key advancements in networking, storage, and computing.
A survey on how hardware developments affect database design, covering key advancements in networking, storage, and computing.
MySQL Performance Declining: Where is Sakila Going?
June 19, 2024 in Database
Higher MySQL versions mean worse performance? Percona monitoring shows slow migration from 5.7 to 8.x. PostgreSQL is pulling ahead.
Higher MySQL versions mean worse performance? Percona monitoring shows slow migration from 5.7 to 8.x. PostgreSQL is pulling ahead.
PostgreSQL's Impressive Scalability
January 13, 2024 in PostgreSQL
This article describes how Cloudflare scaled to support 55 million requests per second using 15 PostgreSQL clusters, and PostgreSQL's scalability performance.
This article describes how Cloudflare scaled to support 55 million requests per second using 15 PostgreSQL clusters, and PostgreSQL's scalability performance.
PostgreSQL Macro Query Optimization with pg_stat_statements
October 26, 2023 in PostgreSQL
**Query optimization** is one of the core responsibilities of DBAs. This article introduces how to use metrics provided by `pg_stat_statements` for macro-level PostgreSQL query optimization.
**Query optimization** is one of the core responsibilities of DBAs. This article introduces how to use metrics provided by `pg_stat_statements` for macro-level PostgreSQL query optimization.
How Powerful is PostgreSQL Really?
August 22, 2022 in PostgreSQL
Let performance data speak: Why PostgreSQL is the world's most advanced open-source relational database, aka the world's most successful database. MySQL vs PostgreSQL performance showdown and distributed database reality check.
Let performance data speak: Why PostgreSQL is the world's most advanced open-source relational database, aka the world's most successful database. MySQL vs PostgreSQL performance showdown and distributed database reality check.
A Methodology for Diagnosing PostgreSQL Slow Queries
February 23, 2021 in PostgreSQL
Slow queries are the sworn enemy of OLTP databases. Here’s how to identify, analyze, and fix them using metrics (Pigsty dashboards), pg_stat_statements, and logs.
Slow queries are the sworn enemy of OLTP databases. Here’s how to identify, analyze, and fix them using metrics (Pigsty dashboards), pg_stat_statements, and logs.
Using sysbench to Test PostgreSQL Performance
February 06, 2018 in PostgreSQL
Although PostgreSQL provides pgbench, sometimes you need sysbench to outperform MySQL.
Although PostgreSQL provides pgbench, sometimes you need sysbench to outperform MySQL.
Testing Disk Performance with FIO
February 06, 2018 in PostgreSQL
FIO is a convenient tool for testing disk I/O performance
FIO is a convenient tool for testing disk I/O performance