Topic
PostgreSQL
All pieces on this topic, newest first.
Results
2026
-
Peer authentication failed for user "postgres" on Ubuntu 24.04
We made “Peer authentication failed for user "postgres"” on a fresh Ubuntu 24.04, read why in the server's log, and logged in with one command.
-
How to install PostgreSQL on Ubuntu 24.04
We installed PostgreSQL on a fresh Ubuntu 24.04 and kept what every command printed, from the first login and “Peer authentication failed” to removing it all again.
-
How many requests per second can one Postgres handle?
One PostgreSQL on a 2-vCPU VM, measured: about 6,000 simple indexed reads per second at 100 % CPU, where p99 starts to climb, and how to estimate your own number.
-
How big should your database connection pool be?
A pool of 4 against a pool of 16 connections on the same Postgres, measured, and Little's law for sizing your own.