May 28, 2026 · Databases

From Installation to High‑Concurrency Tuning: A Hands‑On PostgreSQL Guide

This article walks you through installing PostgreSQL via binary packages or source compilation, securing the instance, and applying memory, connection, and WAL tweaks on a 16‑core, 32 GB server to boost throughput from under 1 k TPS to over 4 k TPS.

InstallationPerformance TuningPostgreSQL

0 likes · 13 min read

From Installation to High‑Concurrency Tuning: A Hands‑On PostgreSQL Guide

dbaplus Community

Feb 12, 2017 · Databases

Can Open‑Source Databases Handle Millions of Queries per Second? PostgreSQL vs MySQL Benchmarks

This article presents a detailed benchmark comparing PostgreSQL 9.6 and MySQL 5.7 on identical high‑end hardware using pgbench and SysBench, describing the test methodology, configuration tweaks, performance results for point selects and OLTP workloads, and concluding that both systems scale to modern demanding workloads.

PostgreSQLSysbenchbenchmark

0 likes · 11 min read

Can Open‑Source Databases Handle Millions of Queries per Second? PostgreSQL vs MySQL Benchmarks