Radim Marek: Same rows, different SUM

https://postgr.es/p/9nx

#postgresql

Same rows, different SUM

Same query, same rows, different SUM totals in PostgreSQL. The culprit is parallel aggregation over double precision floats, not a bug. Here is the mechanism and the fix.

boringSQL | Supercharge your SQL & PostgreSQL powers
pgtt v4.5 has been released

Bangkok, Thailand - June 21, 2026 ## PostgreSQL Global Temporary Tables pgtt is a PostgreSQL extension to create, manage and …

PostgreSQL News

Fuzzing throws malformed, unexpected input at software to find the bugs humans miss. Adam Wolk (Microsoft) brings fuzzing to PostgreSQL at POSETTE: An Event for Postgres 2026.

📺View Adam's talk on YouTube:
https://www.youtube.com/watch?v=F2DJuDX6XHg&list=PLOBORF8Y_l8g

#PosetteConf #PostgreSQL #Postgres #Database #Community #Security #Replication #Microsoft

Rhys Stewart: Armchair Transit with PostGIS: The Census & The Bestagons

https://postgr.es/p/9nw

#postgresql

Armchair Transit with PostGIS: The Census & The Bestagons | Auchindown Blog

Step one in the quest for good transit in Kingston: hexagons, census data, and a whole lot of ST_Intersection.

Auchindown

🚀 How to Deploy #Keycloak on #Ubuntu #VPS (5 Minute Quick-Start Guide)

Here’s a clear and detailed how-to guide for how to deploy Keycloak on Ubuntu VPS. This guide uses Keycloak in standalone mode with #PostgreSQL as the database and #NGINX as a reverse proxy with SSL.
What is Keycloak?
Keycloak is an open-source identity and access management (IAM) ...
Continued 👉 https://blog.radwebhosting.com/deploy-keycloak-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host #selfhosted #identitymanagement #openjdk #opensource #reverseproxy #letsencrypt #selfhosting

Hacking on PostgreSQL can feel overwhelming: massive codebase, rigorous review culture & a long patch queue. Which is why Xuneng Zhou created a Guide to PostgreSQL Hacking at POSETTE 2026.

📺Stream Xuneng's talk on YouTube:
https://www.youtube.com/watch?v=YY8UCINpe5c&list=PLOBORF8Y_l8g

#PosetteConf #PostgreSQL #Postgres #Database #Community #AMD

Senior Backend Engineer (Elixir) at Remote

Remote is hiring Senior Backend Engineer (Elixir)

The phrase "AI-powered analytics" has become so saturated it’s starting to lose its meaning. The reality is that we're navigating a massive utility gap. It’s time to move from "What can AI do?" to "How does AI actually work within my data stack?" https://www.enterprisedb.com/blog/role-ai-data-analytics-moving-hype-high-octane-utility #PostgreSQL
The Role of AI in Data Analytics: Moving From Hype to High-Octane Utility

EDB
🚀 Install and Run Self-hosted #Mattermost Instance on Linux #VPS This article provides a comprehensive guide to install and run self-hosted Mattermost instance on Linux VPS (Ubuntu/Debian). This guide will set up Mattermost with #PostgreSQL and #NGINX as a reverse proxy with HTTPS.
What is Mattermost?
Mattermost is a self-hosted, open-source collaboration platform ...
Continued 👉 https://blog.radwebhosting.com/self-hosted-mattermost-instance/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host #unifiedcommunications #reverseproxy #opensource #selfhosting #selfhosted #letsencrypt

WAL-RUS: a Rust Rewrite of WAL-G for PostgreSQL Backups

https://clickhouse.com/blog/walrus-postgres-backups-in-rust

#postgresql #rust

Why we rewrote WAL-G for Postgres backups in Rust: Meet WAL-RUS | ClickHouse

How we built WAL-RUS, an open-source Rust-based Postgres backup tool that reduces virtual memory usage by over 70% compared to WAL-G while maintaining full compatibility.

ClickHouse