Umair Shahid: Choosing the Right PostgreSQL Partition Key

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

#postgresql

Regina Obe: PostGIS 3.7.0beta2

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

#postgresql

I went one step further and upgraded to PostgreSQL 19 beta 2 #selfhosting #homelab #postgresql

Christophe Pettus: All Your GUCs in a Row: integer_datetimes

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

#postgresql

Zhang Chen: Why I Dare to Call Myself a “PostgreSQL Database Recovery Expert”

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

#postgresql

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

Christophe Pettus: All Your GUCs in a Row: exit_on_error

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

#postgresql

Antony Pegg: Spock 6: The Only Logical Choice

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

#postgresql

Christopher Winslett: Postgres 19 Compression: from pglz to LZ4

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

#postgresql

SHRIDHAR KHANAL: Upgrading PostgreSQL 9.6 to 17 with pg_upgrade

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

#postgresql

Hans-Juergen Schoenig: Philosophy behind pg_hardstorage

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

#postgresql

Karen Jex: How much do you really need to know about databases?

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: event_triggers

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

#postgresql

We used to maintain a mirror of the former #PostgreSQL FTP site. The PostgreSQL project turned off the rsync server it was syncing to about a year and a half ago, so we stopped updating it, but the artifacts as we had them were still being served by the web server, as with a number of other historic FTP servers that had gone AWOL over the decades. When I looked at the logs, what I found was that these millions of hosts were downloading from the PostgreSQL archive.

Jimmy Angelakos: LISTEN Carefully: How NOTIFY Can Trip Up Your Database

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: event_source

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

#postgresql

Regina Obe: Replacing pgAgent with pg_timetable: Part 2 - Installing pg_timetable as a service in Linux

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

#postgresql

Jimmy Angelakos: LinkedIn Live: Fixing Bad SQL in PostgreSQL with Jimmy Angelakos

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

#postgresql

Hans-Juergen Schoenig: How SQL/PGQ Rewrites to Joins on PostgreSQL 19

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: escape_string_warning

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

#postgresql

Pavlo Golub: Swiss PgDay 2026 [UNLOGGED]

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

#postgresql

Cornelia Biacsics: Contributions for week 26 & 27

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

#postgresql

Jimmy Angelakos: PostgresEDI July 2026 Meetup — Public Speaking, AI Compliance

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

#postgresql

Hans-Juergen Schoenig: Architecture behind pg_hardstorage: The replication protocol

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: enable_tidscan

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

#postgresql

Radim Marek: The tests passed. The plan didn't.

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: enable_sort

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

#postgresql

Andrei Lepikhov: Postgres community events: isn't it time to tap the capabilities of the digital era?

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

#postgresql

Andrew Dunstan: (Belatedly) Announcing Release 21 of the PostgreSQL Buildfarm Client

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: enable_seqscan

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: enable_self_join_elimination

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: enable_presorted_aggregate

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

#postgresql

Dave Stokes: Ever Run Into A PostgreSQL Query That You Can Figure Out What It Does??

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

#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

Christophe Pettus: The Version Number Is Not the Territory

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

#postgresql

Floor Drees: EDB heads to PGConf.Brasil 2026, this is what we’ll be talking about!

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

#postgresql

Vibhor Kumar: PostgreSQL, AI Governance, and the C.A.L.M. Platform Test

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

#postgresql

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

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 20 – Add min() and max() aggregate support for uuid.

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

#postgresql

@adamchainz @ngnpope @felixxm you can also have a generated field with the creation time extracted from the uuid which can be more efficient ;-)

https://www.paulox.net/2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/#adding-the-creation_time-generated-column

#Django #UUID #UUIDv7 #PostgreSQL

Haki Benita: How to Achieve Pruning When Querying by Non-Partitioned Columns in PostgreSQL

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

#postgresql

Ruohang Feng: Happy 30th Birthday, PostgreSQL

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

#postgresql

🎤 Speaker Spotlight

Elizabeth Christensen joins DjangoCon US 2026 with:

"What's New in Postgres 18 & 19"

Learn which new PostgreSQL features are ready for your Django apps and which ones can wait.

#Django #Python #PostgreSQL

Christophe Pettus: All Your GUCs in a Row: enable_partitionwise_join

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

#postgresql

Mayur B.: My Dishonest Benchmark

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

#postgresql

SHRIDHAR KHANAL: PostgreSQL Disaster Recovery with pgBackRest TLS Transport

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

#postgresql

You probably don't need another database.

https://postgresisenough.dev

#PostgreSQL

RE: https://fosstodon.org/@blainsmith/116873730352706803

Something that I’d like someone to explain: #PostgreSQL is a long-lived open-source project that never seemed to have drama around it, unlike, oh, Emacs, Linux, Python, Rails, etc.

Did I just not see the drama, coming from a different niche? If it wasn't there, it'd be *important* (as open source is being overwhelmed) to know why.

Christophe Pettus: All Your GUCs in a Row: enable_partitionwise_aggregate

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

#postgresql

Richard Yen: Are You .ready?

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

#postgresql

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 20 – Add backend-level lock statistics

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

#postgresql

Michael Banck: Replication Deadlock Bug in Current Postgres Releases 14-16

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

#postgresql

Devrim GÜNDÜZ: Inaugural PostgreSQL Istanbul Meetup was a blast!

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

#postgresql

Floor Drees: Jumping the gun: looking ahead at PostgreSQL 19

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

#postgresql

Blog: synchronisation des slots de réplication logique : https://www.loxodata.com/post/logical-replication-slot-sync/
#PostgreSQL

Gabriele Bartolini: CNPG Recipe 25 - Declarative Roles and Passwordless TLS in CloudNativePG 1.30

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

#postgresql

Hans-Juergen Schoenig: Why pg_hardstorage has no incremental chain

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: enable_partition_pruning

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

#postgresql

Regina Obe: PostGIS 3.7.0alpha1

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

#postgresql

Radim Marek: VACUUM at the Page Level

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: enable_parallel_hash

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

#postgresql

Henrietta Dombrovskaya: PG DATA 2026 recap, and looking forward to PG DATA 2027

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: enable_parallel_append

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

#postgresql

Shaun Thomas: Looking Forward to Postgres 19: Checksums For All

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

#postgresql

Hans-Juergen Schoenig: Following a Backup from PostgreSQL to Recovery using pg_hardstorage

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

#postgresql

Floor Drees: Meeting in Montreal: Developer U plan(ner) patches

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

#postgresql

Antony Pegg: How to Build a RAG Server on pgEdge Cloud via the API

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

#postgresql

Thom Brown: LOAD "PL/CBMBASIC",8,1: Commodore 64 BASIC for PostgreSQL

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

#postgresql

Henrietta Dombrovskaya: Estonia PUG Meetup

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: enable_nestloop

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

#postgresql

Zhang Chen: Extreme Rescue: PostgreSQL Full-File Ransomware Recovery at Epic Difficulty

https://postgr.es/p/9n-

#postgresql

Christophe Pettus: All Your GUCs in a Row: enable_mergejoin

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

#postgresql

Ahsan Hadi: Introducing pg-healthcheck: PostgreSQL Health Diagnostics

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

#postgresql

Dimitri Fontaine: pgcopydb v0.18

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

#postgresql

warda bibi: Inside a PostgreSQL Checkpointer Bug: A Production Postmortem

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

#postgresql

Stefanie Janine Stölting: pgsql_tweaks Version 1.0.5 Released

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

#postgresql

Zhang Chen: The PostgreSQL Feature That Makes Data Recovery Painful

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: enable_material and enable_memoize

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

#postgresql

My #Postgresql #mgmtconfig talk submission to @pgconfeu has been #REJECTED!

(Promote transparency and post your rejections too!)

Gülçin Yıldırım Jelínek: PostgreSQL as a temporal database

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

#postgresql

Viacheslav Sarzhan: Community Docker Images: keeping the operator open without a vendor registry lock-in

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

#postgresql

Peter Eisentraut: Waiting for SQL:202y: Stockholm (BMA) meeting report

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

#postgresql

Laurenz Albe: Too many tables are bad for you

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

#postgresql

Laurenz Albe: Impressions from the Swiss PGDay(s) 2026

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: enable_indexonlyscan

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

#postgresql

vignesh C: Closing a critical gap in PostgreSQL upgrade workflows with sequence synchronization

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

#postgresql

Richard Yen: Disaster Recovery is a Process, Not a Tool (Part 2)

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

#postgresql

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

Deepak Mahto: The Oracle NUMBER Trap: How One Data Type Decision Quietly Slows Down Your PostgreSQL Migration

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

#postgresql

Cornelia Biacsics: Contributions for week 25

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: enable_incremental_sort

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

#postgresql

Radim Marek: Same rows, different SUM

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

#postgresql

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

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: enable_hashjoin

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

#postgresql

Lætitia AVROT: Stop Punishing Your Postgres for a Crash That Won't Happen

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: enable_hashagg

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

#postgresql

Andrei Lepikhov: A Generative Postgres Digest: From Noise to Signal

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

#postgresql

Christophe Pettus: coddpiece: Watch Relational Algebra Become SQL

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

#postgresql

Shaun Thomas: Looking Forward to Postgres 19: Split Personality

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

#postgresql

Jan Wieremjewicz: Why PostgreSQL needs an AI usage policy

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: enable_gathermerge

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

#postgresql

SHRIDHAR KHANAL: PostgreSQL Disaster Recovery with pgBackRest TLS Transport

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

#postgresql

#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

Hans-Juergen Schoenig: Heterogeneous Graphs in SQL/PGQ on PostgreSQL 19

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: enable_distinct_reordering and enable_group_by_reordering

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

#postgresql

Vibhor Kumar: The AI Agent Layer: Architecture, Implementation, and the Future of Intelligent Enterprise Systems

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

#postgresql

Christophe Pettus: cygnet: A small but fierce ORM

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

#postgresql

Shaun Thomas: The Long Road to Bottomless Postgres

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

#postgresql

warda bibi: MCP For PostgreSQL: Automated Health Checks & Performance Analysis

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

#postgresql

Jeremy Schneider: Happiness Hint: Alarm on Checkpoint Time

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: enable_indexscan and enable_bitmapscan

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

#postgresql

David Wheeler: pg_clickhouse 0.3.2: Ready For Postgres 19

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

#postgresql

Hans-Juergen Schoenig: Introducing pg_hardstorage: A New Community-Driven Approach to PostgreSQL Backup and Recovery

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

#postgresql

Tomas Vondra: Some more thoughts on random_page_cost

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

#postgresql

#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

Christophe Pettus: All Your GUCs in a Row: enable_async_append

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

#postgresql

Regina Obe: PostGIS Tiger Geocoder 2025.1

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

#postgresql

Andreas Scherbaum: PostgreSQL Berlin May 2026 Meetup

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

#postgresql

Richard Yen: pg_stats: How Postgres Internal Stats Work

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

#postgresql

Christophe Pettus: waxsql: Wax Fruit for Your Query Planner

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

#postgresql

Cornelia Biacsics: Contributions for week 23 & 24, 2026

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: effective_io_concurrency

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

#postgresql

Regina Obe: Replacing pgAgent with pg_timetable: Part 1

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: effective_cache_size

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

#postgresql

Andrei Lepikhov: Optimising Polymorphic Associations in PostgreSQL

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: dynamic_shared_memory_type

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

#postgresql

Shaun Thomas: Looking Forward to Postgres 19: Logically Sequenced

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

#postgresql

Stefanie Janine Stölting: pgsql_tweaks Version 1.0.4 Released

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

#postgresql

Lætitia AVROT: It's Not Magic, It's Method

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: dynamic_library_path

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

#postgresql

Antony Pegg: Introducing ColdFront: Seamlessly Uniting OLTP, Analytics and AI Workloads on PostgreSQL

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

#postgresql

Antony Pegg: Your AI App Works on Postgres. Now Make It Production-Ready Without Starting Over

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: default_transaction_isolation and default_transaction_read_only

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

#postgresql

My talk from @posetteconf : An Event for Postgres 2026 is now available on YouTube 🎥🐘

If you missed it live, you can now watch “PostgreSQL Generated Columns by Example” online.

I’ve also collected links and additional information on my blog, and I plan to publish the slides there next week ✨

https://youtu.be/wExoyNdua0g

#PostgreSQL #POSETTE #Python #Postgres #Django

Vibhor Kumar: The AI Agent Layer: Architecture, Implementation, and the Future of Intelligent Enterprise Systems

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

#postgresql

now I'm calculating elevation profiles using the #gebco dataset https://www.gebco.net/data-products-gridded-bathymetry-data/gebco2026-grid
with #postgresql #postgis rasters and #charts https://chartscss.org/ https://github.com/docteurklein/httpg/blob/cae042e1e9357bc538e0e61ea6dd47ec72c588f9/gps/sql/view.sql#L151

Alt...

select st_value(rast, p.geom), coalesce(st_value(rast, p.geom) / max(st_value(rast, p.geom)) over ()::decimal, 0) from point p left join gebco_geo on st_contains(gebco_geo.geom, p.geom)

Alt...

a line chart showing elevation gain and loss during a run

Qiaosheng Liu: Releasing pg_ducklake v1.0

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

#postgresql

Payal Singh: Postgres War Stories Part 2: multixact wraparound, TOAST corruption, and torn pages

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: default_transaction_deferrable

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

#postgresql

Andrew Atkinson: Scaling Rails at Aura Frames: Splitting to 8 Primary DBs and Reaching #1 in the App Store

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

#postgresql

Andrew Atkinson: From Christmas Outage to #1 App Store Ranking: An Aura Frames Postgres Scaling Retrospective

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

#postgresql

Andrew Atkinson: Scaling Rails at Aura Frames: Splitting to 8 Primary DBs and Reaching #1 in the App Store

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

#postgresql

Andrew Atkinson: From Christmas Outage to #1 App Store Ranking: An Aura Frames Postgres Scaling Retrospective

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

#postgresql

Noémi Ványi: pgstream v1.1.0: Steps towards turning it into a service

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

#postgresql

Christopher Winslett: British Columbia, Time Zones, and Postgres

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

#postgresql

Dian Fay: What LLMs are Doing to Conference Programs, and How to Use Them Effectively if You're Going to Do It Anyway

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

#postgresql

semab tariq: How To Run Logical Replication On A Production PostgreSQL Cluster

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: default_toast_compression

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: default_text_search_config

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

#postgresql

Richard Yen: Disaster Recovery is a Process, Not a Tool (Part 1)

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

#postgresql

Robins Tharakan: Why Postgres Doesn't Have remote_receive - And What Happened When I Tried It

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

#postgresql

Radim Marek: The NULL in your NOT IN

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: default_tablespace

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

#postgresql

Gilles Darold: pg_kpart PostgreSQL extension

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: default_table_access_method

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

#postgresql

Proxmox Mail Gateway 9.1 erleichtert Kampf gegen Spam und verschlüsselt Backups

Das neue Proxmox Mail Gateway will mehr Komfort beim Mail-Handling bieten und die Möglichkeit, ihre Backups zu verschlüsseln.

https://www.heise.de/news/Proxmox-Mail-Gateway-9-1-erleichtert-Kampf-gegen-Spam-und-verschluesselt-Backups-11330653.html?wt_mc=sm.red.ho.mastodon.mastodon.md_beitraege.md_beitraege&utm_source=mastodon

#Datenschutz #EMail #IT #Linux #OpenSource #PostgreSQL #Spam #Verschlüsselung #news

semab tariq: When Patroni Silently Deletes Your Replication Slots

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

#postgresql

Shaun Thomas: Looking Forward to Postgres 19: It's About Time

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

#postgresql

PgDog: a open-source Proxy for scaling PostgreSQL. It supports connection pooling, load balancing queries and sharding entire Databases. Written in Rust, it is fast, secure and can manage Thousands of Connections on commodity Hardware #PostgreSQL https://pgdog.dev/

The TAP tests of PostgreSQL use moons emojis as a progress bar. This is brilliant.

🌕 🌔 🌓 🌒 🌑 🌘 🌗 🌖 🌕

#postgresql

Alt...

Screenshot of a terminal showing the ongoing TAP tests of PostgreSQL with the last line showing a mostly yellow moon.

Alt...

Screenshot of a terminal showing the ongoing TAP tests of PostgreSQL with the last line showing a mostly dark moon.

Christophe Pettus: All Your GUCs in a Row: default_statistics_target

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

#postgresql

Andrew Dunstan: Buildfarm Query API

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

#postgresql

Tudor Golubenco: A thousand Postgres branches for $1

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

#postgresql

Christophe Pettus: How the Other Half Plans

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

#postgresql

Dave Page: Inside the pgEdge AI DBA Workbench: How Ellie Actually Works

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

#postgresql

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

Richard Yen: PGDay Boston 2026

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: the debug_* family

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

#postgresql

Richard Yen: PGDay Boston 2026

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: deadlock_timeout

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

#postgresql

now I track my GPS position using my browser and use #h3 and #postgis to create a traffic density heatmap, with very few code thanks to #httpg and #postgresql https://github.com/docteurklein/httpg/blob/main/gps/sql/view.sql

Alt...

create or replace view heatmap (hex, weight) as select ST_CoverageClean(h3_cell_to_boundary_geometry(location @ 10)) over (), count(*) from ping group by location @ 10 order by 2;

Alt...

a map showing a running segment with coloration to show traffic density

Christoph Berg: PGConf.dev 2026 in Vancouver

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

#postgresql

Cornelia Biacsics: Contributions for week 22, 2026

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

#postgresql

Stefanie Janine: My Three Top PostgeSQL 19 Features

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: DateStyle

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

#postgresql

Christophe Pettus: How the Other Half Counts

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

#postgresql

Vibhor Kumar: pg_background 2.0: Run SQL in the Background, Now Cleaner, Safer, and Ready for PostgreSQL 19

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

#postgresql

Stefanie Janine Stölting: pgsql_tweaks Version 1.0.3 Released

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: data_sync_retry

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: data_directory_mode

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

#postgresql

Andrew Atkinson: Beta Testing PostgreSQL With Docker

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: data_directory

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

#postgresql

Mark Wong: Acknowledged Individuals in the PostgreSQL Release Notes: 2026 Edition

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

#postgresql

Lætitia AVROT: A Reviewer Was Born

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

#postgresql

Shaun Thomas: Looking Forward to Postgres 19: Query Hints

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

#postgresql

Floor Drees: How to test PostgreSQL 19 beta in your Kubernetes cluster

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

#postgresql