Bases de donnéesPlanet PostgreSQL
Bases de données
Replication slots promise to keep WAL forever—until PostgreSQL 18's new `idle_replication_slot_timeout` puts an expiration date on abandoned ones before they…
Today, we are pleased to announce the GA of Elastic 9.5 as the latest version of the Elasticsearch Platform. This release includes a range of new features, including Columnar Mode, VectorDB index mode, and Agent Builder enhancements. Learn…
“The database is locked up.” We heard some version of that sentence more than once this past week, from the same team, about what looked like the same problem. It was not the same problem. Once, Postgres had genuinely stopped responding.…
That's 320 milliseconds vs 671 ms for exact COUNT(DISTINCT) which is about twice as fast on a single scan. Also HLL isn't just about raw speed on one query. The function names are a bit verbose but the pattern is always the same: hash the…