Christophe Pettus: All Your GUCs in a Row: enable_incremental_sort

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

#postgresql

All Your GUCs in a Row: enable_incremental_sort

Incremental sort exploits presorted data to avoid expensive full sorts, but cost estimation errors on skewed data can backfire.

AngaraBase: новая HTAP СУБД

AngaraBase — OLTP/HTAP СУБД, написанная с нуля на Rust. Совместима с PostgreSQL по протоколу — работает с psql, JDBC, psycopg2 и стандартными драйверами. UNDO-log MVCC без VACUUM, векторизованный исполнитель с SIMD-батчами — транзакции и аналитика под одним SQL и одним снапшотом, без ETL и второго хранилища. Fail-closed контракты ресурсов, USDT-пробы без рестарта, EXPLAIN с разбивкой по фазам исполнения. Dev preview доступен на angarabase.dev.

https://habr.com/ru/articles/1053076/

#HTAP #СУБД #AngaraBase #Rust #MVCC #бэкап #USDT #eBPF #PostgreSQL #векторизация

AngaraBase: новая HTAP СУБД

Это продолжение цикла статей про нашу СУБД на Rust. Предыдущие были про устройство ядра по подсистемам: Мы знаем как готовить БД. Но индустрия изменилась: что бы я заложил в OLTP-БД с нуля Контракт...

Хабр
Senior Site Reliability Engineer - Database Services at GoDaddy

GoDaddy is hiring Senior Site Reliability Engineer - Database Services

Learn to build a functional web API with Go 1.26, covering RESTful endpoints, database persistence with PostgreSQL and GORM, and testing best practices in under an hour.

#Go programming #Web API #RESTful API #PostgreSQL #GORM

https://dasroot.net/posts/2026/02/build-web-api-go-under-an-hour/

Build a Web API with Go in Under an Hour

Learn to build a functional web API with Go 1.26, covering RESTful endpoints, database persistence with PostgreSQL and GORM, and testing best practices in under an hour.

Technical news about AI, coding and all

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