DatabasePlanet PostgreSQL
Database
PostgreSQL 13 made hash aggregation memory-safe by allowing it to spill to disk — but that safety introduced a surprise regression for some queries on upgrade.
Learn relational algebra by building expressions that compile to real SQL.
We often hear that open source is about people. People who contribute their time and, in a way, parts of their lives to work on software that is available for everyone without limitations and without licensing costs. The more popular a…
Postgres has had native support for declarative partitions since version 10, and every release since has filed off another rough edge. We got partition-wise joins, default partitions, hash partitioning, and the ability to attach and detach…