Stackrig

Home Blog Topics

Topic

PostgreSQL

All pieces on this topic, newest first.

2026

  1. tested Ubuntu 24.04

    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.

  2. tested Ubuntu 24.04

    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.

  3. measured

    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.

  4. measured

    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.