Upgraded all my PostgreSQL 17 containers to 18 this morning #selfhosting #homelab #postgresql

Vibhor Kumar: The Enterprise AI Trust Stack: How OWNS, CALM, and ORBIT Fit Together

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: ignore_system_indexes

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

#postgresql

Devrim GÜNDÜZ: Release Radar: A Self-Hosted Watchtower for Upstream Releases (and Why It Matters for PGDG Packaging)

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

#postgresql

Shaun Thomas: Looking Forward to Postgres 19: Syntax Potpourri

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

#postgresql

Cornelia Biacsics: Contributions for week 29 & 30

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

#postgresql

Andrei Mironov: PostgreSQL Row-Level Security for AI Agents: A Testable Setup

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

#postgresql

REPLAY : en mai dernier, Pierrick intervenait aux #RPLL pour présenter CloudNativePG, l'opérateur Kubernetes pour PostgreSQL
=> https://dali.bo/202608_conf_rpll_cnpg

Merci au @plossra_a pour ce partage !

#PostgreSQL #sgbd #dba
#CNPG #CloudNativePG
#Kubernetes #K8S
#opensource
#conference

Alt...

Capture de la vidéo

Alexey Evlampiev: Your Transaction Boundary Belongs in the Program, Not the Filename

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

#postgresql

Alexey Evlampiev: Your ALTER TABLE Is Fast. The Queue Behind It Is Not.

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: ignore_invalid_pages

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

#postgresql

Mayur B.: EXPLAIN ANALYZE the PGConf.EU CFP

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

#postgresql

Antony Pegg: Postgres for Agentic AI: Your Database Is a Compute Layer, Not a Parking Lot

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

#postgresql

Pavel Stehule: initial integration lua language to psql

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

#postgresql

Vibhor Kumar: ORBIT: An Execution Framework for Reliable Enterprise AI

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

#postgresql

Gabriele Bartolini: CNPG Recipe 26 - Extension image catalogs

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

#postgresql

Today I realized that I have my own preferred software dev stack that is really, really good:

- #Kotlin
- #JavaFX
- #H2 for embedded db
- #PostgreSQL for server db

No browser required. Not C fast, but definitely fast enough. Runs pretty much anywhere. Great tooling. A library for just about anything. The only real downside is #Gradle, but JetBrains are working on that, too.

#programming

Christophe Pettus: All Your GUCs in a Row: ignore_checksum_failure

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

#postgresql

Radim Marek: The DISTINCT in your COUNT

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

#postgresql

Christophe Pettus: Ontogeny Recapitulates the Relcache

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

#postgresql

Wellingtone Luvonga: Mastering PostgreSQL Configuration Management with CloudNativePG (CNPG)

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

#postgresql

Avi Vallarapu: Tuning PostgreSQL HOT Updates - A HammerDB Benchmark

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

#postgresql

We have switched to using https://pgBackRest.org for backups of our primary database 🗄️, covering both #PostgreSQL base backups and WAL archives. This has allowed us to optimise the weekly planetfile-generation pipeline 🌍, these weekly exports will now be published earlier in the week. A big thank you to the #pgBackRest team for a great product! 🙌

Christophe Pettus: All Your GUCs in a Row: idle_session_timeout

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: idle_replication_slot_timeout

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

#postgresql

Elizabeth Garrett Christensen: Postgres COUNT(DISTINCT) Too Slow? Fast Approximation Guide

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

#postgresql

Umair Shahid: PostgreSQL Lockup vs Stale Connection: How to Tell Them Apart

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: idle_in_transaction_session_timeout

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: ident_file

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: hot_standby_feedback

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

#postgresql

Mark Wong: Performance Farm July 2026 Update

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

#postgresql

Pavlo Golub: WAWTech+Summer 2026 [UNLOGGED]

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

#postgresql

Muhammad Aqeel: PostgreSQL 18's extension_control_path: Decoupling Extensions from Server Images

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

#postgresql

Shaun Thomas: Looking Forward to Postgres 19: The Cult of Functionality

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

#postgresql

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 19 – SQL Property Graph Queries (SQL/PGQ)

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

#postgresql

Robert Haas: Hacking Workshop for September 2026

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: hot_standby

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

#postgresql

Christopher Winslett: Hybrid Search Patterns with Postgres and pgvector

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

#postgresql

Pavlo Golub: vip-manager v5 is out: what you need to know

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

#postgresql

Stefanie Janine: ProOpenSource is now an Open Alliance for PostgreSQL Education Supporter

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: hba_file

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

#postgresql

Sehrope Sarkuni: Introducing pg-java, a new PostgreSQL driver for the JVM

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

#postgresql

Dave Stokes: AI Chat With DBeaver Community Edition

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: hash_mem_multiplier

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

#postgresql

Dimitri Fontaine: SQL Improvements in PostgreSQL 11–18: A Personal Selection

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

#postgresql

PostgreSQL's MVCC is bad. So is everyone else's

https://boringsql.com/posts/mvcc-bad-bad/

#postgresql

Hans-Juergen Schoenig: Data Lineage in PostgreSQL 19: Finally, an Answer When the CFO Asks "Where Did This Number Come From?"

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: gss_accept_delegation

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

#postgresql

Hayato Kuroda: Highlights of Fujitsu's contribution in PostgreSQL 19

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

#postgresql

Vibhor Kumar: The CALM Platform Test

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

#postgresql

Radim Marek: PostgreSQL's MVCC is bad. So is everyone else's.

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

#postgresql

Zhang Chen: PostgreSQL data recovery checklist: what to preserve before you touch PGDATA

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: gin_fuzzy_search_limit

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

#postgresql

Andrei Lepikhov: Why your pioneering Postgres feature should start in a fork

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

#postgresql

Bruce Momjian: Postgres AI Workshop

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: The geqo Family

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: full_page_writes

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

#postgresql

Shaun Thomas: Looking Forward to Postgres 19: Autovacuum Tweaks

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

#postgresql

#Postgres #PostgreSQL

Christophe Pettus: All Your GUCs in a Row: fsync

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

#postgresql

Ahsan Hadi: Hybrid Search in PostgreSQL: BM25, Sparse Vectors, and Reciprocal Rank Fusion

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

#postgresql

SHRIDHAR KHANAL: The Right Way to Give a Third-Party DBA Access to Your PostgreSQL Database

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

#postgresql

Floor Drees: Big Apple, Big PostgreSQL: EDB at Postgres Summit US 2026

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

#postgresql

RE: https://mastodon.social/@nixCraft/116967651925817801

Why does the BSD mailing list, or the PostgreSQL source code which is related to BSD in some way, use double spaces after a period in the computer era?

#bsd #postgresql

PulkoMandy boosted

nixCraft 🐧 » 🌐 2026-07-23 / 2026-07-23
@nixCraft@mastodon.social

FreeBSD Ports Repository Freeze: A 150MB binary file was recently committed to the ports tree and, as a result, core@ made the decision to implement a temporary freeze of the ports tree in order to implement some clean up efforts. There is no concern that the ports tree has been compromised

https://lists.freebsd.org/archives/freebsd-announce/2026-July/000294.html

Christophe Pettus: All Your GUCs in a Row: from_collapse_limit

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

#postgresql

Paul Jungwirth: TQuel Paper

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: file_extend_method

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

#postgresql

Abhisek Goswami: PostgreSQL vs Destructive Time Travel: The Year 2038 Problem

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

#postgresql

Cornelia Biacsics: Building The OAPE PostgreSQL Certification

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

#postgresql

Candidature rejetée, après deux entretiens, parce que l'entreprise «s'oriente vers une adoption forte de l'IA dans ses pratiques de développement, une direction qui ne semble pas alignée avec vos attentes à ce stade».

Est-ce qu'il y a encore des éditeurs de logiciels en France qui sont prêts à embaucher un développeur qui préfère écrire lui-même son code ?

#GetFediHired #Rust #Scala #Python #PostgreSQL

Regina Obe: PostGIS 3.7.0beta1

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

#postgresql

Cornelia Biacsics: Contributions for week 28

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: file_copy_method

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

#postgresql

Hans-Juergen Schoenig: Moving to pg_hardstorage without changing your recovery strategy

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: extra_float_digits

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

#postgresql

Henrietta Dombrovskaya: Prairie Postgres July Meetup: Proudly Sourced at Midwest!

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

#postgresql

Andrei Lepikhov: Openness or Oblivion

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: external_pid_file

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: extension_control_path

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

#postgresql

Shaun Thomas: Looking Forward to Postgres 19: Checkpoint Control

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

#postgresql

TECH : la performance des requêtes, c'est le dada d'Alain ! Pour vous aider à les améliorer, il en vous propose de découvrir le paramètre default_statistics_target => https://blog.dalibo.com/2026/07/10/statistics-target.html

#PostgreSQL #SQL
#SGBD #DBA
#opensource

Alt...

capture de l'article

RELEASE : #ldap2pg est l'outil de synchronisation des rôles et des ACLs développé par nos collègues Étienne et Pierre-Louis.
Sa dernière version implémente l’authentification GSSAPI/Kerberos => https://blog.dalibo.com/2026/07/07/ldap2pg-6.6.html

#PostgreSQL #SGBD
#ldap #GSSAPI
#opensource #dalibolabs

Alt...

visuel ldap2pg

RELEASE : voici un nouvel outil basé sur #pgBackRest, pour sauvegarder les instances #PostgreSQL déployés avec #CloudNativePG !

Deux de ses développeurs vous en parlent => https://blog.dalibo.com/2026/06/25/plugin-pgbackrest.html

🇬🇧 => *Here is the announcement of our experimental CloudNativePG plugin to backup PostgreSQL instances with pgBackRest!*

#SGBD #CNPG #DBA
#kubernetes
#opensource

Alt...

capture de l'article

#pgBackRest : Dalibo fait désormais partie de ses sponsors => https://blog.dalibo.com/2026/06/25/pgbackrest_communautaire.html

Après le coup d'arrêt du projet annoncé par son mainteneur en avril dernier, des membres de la communauté #PostgreSQL se sont mobilisés rapidement. 🐘 🐘 🐘

Notre SCOP est très fière de les avoir rejoints, consciente de son devoir de contribution.

#sgbd #opensource #logicielsLibres

Alt...

capture de l'article

#pgsession19 : bien qu'elle aura lieu en janvier 2027, nous lançons dès aujourd'hui notre appel à #conférences =>
https://blog.dalibo.com/2026/06/23/pgsession19_cfp.html

Date-limite : 29 octobre… vous avez le temps. 😎

#PostgreSQL #cfp
#opensource #sgbd #dba

Alt...

visuel de l'appel à conférences

SAVE THE DATE : vous souhaitez mettre à jour vos connaissances sur #PostgreSQL ?

📣 Les journées Ateliers et Conférences de la #pgsession19 auront lieu les **12 et 13 janvier 2027** à Paris =>
https://blog.dalibo.com/2026/06/11/pgsession_19.html

#SGBD #DBA #opensource
#conférences #workshops

Alt...

Visuel de promo de la PGSession 19, prévue en janvier 2027

Christophe Pettus: Patch PgBouncer Today

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

#postgresql

RELEASE : annonce de fin de vie de la v.14, correctifs de sécurité, améliorations et conseils pour mettre à jour votre #SGBD… Voici notre traduction de l'annonce communautaire =>
https://blog.dalibo.com/2026/05/15/postgresql_release_18.4.html

#PostgreSQL #opensource #DBA #update

Alt...

capture

#pgbackrest is dead. What next?

https://mydbanotebook.org/posts/pgbackrest-is-dead.-now-what/

#PostgreSQL