DatabasesPlanet PostgreSQL
Databases
Six months ago we started writing the PostgreSQL backup tool we kept wishing existed. Now pg_hardstorage has shipped, and you can read every line of it on GitHub before you trust it with your WAL stream. Why another backup tool? At…
When you are upgrading across major PostgreSQL versions, there are a few ways to go. Dump and restore is the simplest to reason about, but downtime scales directly with database size, so for anything multi-terabyte, it is off the table.…
Gwen Shapira shares how teams are scaling AI features using PostgreSQL for mission-critical apps. She explains how to leverage Postgres's multi-modal capabilities - including JSONB parsing and high-recall HNSW vector indexing - to deliver…
When most people start working with PostgreSQL, they quickly learn SQL: [crayon-6a58c0c29e340866286469/] But very soon, another world opens up inside psql — a set of commands that don’t look like SQL, don’t end with semicolons. These are…