Kai Wagner: LaserFocus - Keeping Our Goals in Sight

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

#postgresql

Jobin Augustine: PgQ and PgQue: Workflow Engines you might need in PostgreSQL

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

#postgresql

Devrim GÜNDÜZ: Using the PGDG RPM repositories are now way easier!

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

#postgresql

Phillip Merrick: Why We Built pgEdge Starfleet

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

#postgresql

Cornelia Biacsics: Contributions for week 38

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: max_sync_workers_per_subscription

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

#postgresql

Devrim GÜNDÜZ: RHEL / Rocky Linux / AlmaLinux repository RPMs now follow the OS minor version

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

#postgresql

Radim Marek: What REPACK (CONCURRENTLY) costs while it runs

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

#postgresql

Chris van Eijk: PostgreSQL indexes for multi-tenant SaaS: tenant_id first

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

#postgresql

Chris van Eijk: Invoice numbers per tenant in PostgreSQL, without gaps

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

#postgresql

Vibhor Kumar: What “AI-Ready” Actually Means

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: max_standby_archive_delay and max_standby_streaming_delay

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

#postgresql

Mikhail Shytsko: Our Interleaved Backfill Wrote Three Times the WAL

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

#postgresql

Three years after my talk about TimescaleDB, we are streaming events to Kafka using Debezium and the special TimescaleDb SMT. We had unexplained issues for months. Connectors failed during the night multiple times a week. A restart solved the issue but sometimes, it led to other unrelated issues waking us up at night.

Last week, we had one of those night/early morning. I decided to take a deeper look because it has to stop. I discovered that our HAProxy instances cut idle sessions after 30 minutes. When a chunk is rotated, the SMT did a query on the catalog tables and failed with an unrecovered error. A very similar error handling has just been committed (connection reset by peer). I just had to add an EOFException to the list and it's already committed https://github.com/debezium/debezium/pull/8099

During this debug session, we've seen some warnings that recently dropped chunks were not found so they created their own topic instead of routing events to the main topic (which defeat the purpose of a SMT). That issue is now solved too https://github.com/debezium/debezium/pull/8109

We also have an issue with random JSON parsing errors of the response of the Schema Registry when serializing Avro messages in the backlog, but we need to dig a little deeper before.

Can't wait to deploy the next release!

#debezium #timescaledb #postgresql #opensource #foss

Christophe Pettus: All Your GUCs in a Row: max_slot_wal_keep_size

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: max_replication_slots

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

#postgresql

Andrew Atkinson: Let’s Get Down to Business with Rails and PostgreSQL

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

#postgresql

Umair Shahid: Your Postgres Database Is Slow, and It Isn’t Postgres

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

#postgresql

Dmitry Narizhnykh: How to Inspect a pg_dump Without Restoring It

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

#postgresql

Cornelia Biacsics: What Development Looked Like at PGConf.dev 2026

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: max_prepared_transactions

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

#postgresql

Robert Haas: Hacking Workshop for October 2026

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

#postgresql

Stefan Fercot: pgBackRest and PostgreSQL failover: why archive_mode matters

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

#postgresql

TECH : quelles solutions pour transpiler du SQL d'un dialecte à l'autre en 2026 ? Étienne partage mon avis après trois ans de développement sur la migration vers PostgreSQL
=> https://bersace.cae.li/posts/transpiler-sql/

#SQL #PostgreSQL
#opensource

Alt...

capture de l'article Transpiler SQL

Mehmet Ince: Part 2/6 | Breaking the Postgres Superuser Guardrails: Attacking Security-Hardening Extensions |Systemic Risks in the Managed PostgreSQL Industry

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: max_pred_locks_per_transaction

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

#postgresql

Christophe Pettus: The Shadow Knows

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

#postgresql

Dimitri Fontaine: Ten years of Postgres logical replication

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

#postgresql

Chris van Eijk: Multi-tenant SaaS on PostgreSQL: six decisions

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

#postgresql

Chris van Eijk: Row-level security in PostgreSQL: where tenants leak

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

#postgresql

Chris van Eijk: Money in PostgreSQL: numeric, integer cents or money?

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

#postgresql

Mikhail Shytsko: Forty Deletes Vanished From pg_stat_statements

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

#postgresql

Tomas Vondra: Being considerate of other people's time

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: max_pred_locks_per_page and max_pred_locks_per_relation

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

#postgresql

Bruce Momjian: The Promise of Non-Volatile Memory

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

#postgresql

Cornelia Biacsics: Contributions for week 37

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: max_parallel_apply_workers_per_subscription

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

#postgresql

Ruohang Feng: PostgreSQL's Chinese Error Messages Were Seven Years Stale. Not Anymore.

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: max_parallel_workers and max_parallel_workers_per_gather

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

#postgresql

Henrietta Dombrovskaya: Major updates to pg_acm

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

#postgresql

Shaun Thomas: Looking Forward to Postgres 19: Epilogue

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: max_parallel_maintenance_workers

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

#postgresql

Mark Wong: Sizing an OLTP TPC-E-like workload, Part 1

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

#postgresql

Mikhail Shytsko: Your Agent Is Reading Someone Else's Tenant

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

#postgresql

Jimmy Angelakos: postgres.scot is live, August PostgresEDI meetup

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: max_notify_queue_pages

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

#postgresql

Joshua Drake: pgColumnar 1.0-alpha4 released

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

#postgresql

Muhammad Aqeel: Flexible Deployment: What Enterprise-Grade Self-Hosting Actually Demands

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

#postgresql

Ryan Booz: Postgres Monitoring for SQL Server DBAs: Statistics and Logs 101

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

#postgresql

Ryan Booz: Postgres in Production Special Series: How to Query pg_stat_statements to Find Slow and Expensive Postgres Queries (Part 7)

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

#postgresql

Christophe Pettus: The Call Is Coming From Inside the Session

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

#postgresql

Gülçin Yıldırım Jelínek: Postgres week in the Netherlands: PGDay Lowlands & Percona Live 2026

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

#postgresql

Radim Marek: Row locks at the page level

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: max_logical_replication_workers

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

#postgresql

Elizabeth Garrett Christensen: PostgreSQL 19 Delayed: Key Feature Reversions & Release Updates

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

#postgresql

Joshua Drake: PostgreSQL 19: Sept 08 - Sept 16, 2026

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

#postgresql

Florent Jardin: Inspecting a catalog with pg_migrate

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: max_locks_per_transaction

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

#postgresql

Jeremy Schneider: Agents Gone Awry on Postgres SBOMs: Start Over

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

#postgresql

Alexander Ioffe: Postgres runs your query fast exactly five times. Then it changes its mind. One prepared statement, twelve EXPLAIN ANALYZE runs on one connection, a plan change on run six, and why a single run could never have shown it.

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

#postgresql

Dimitri Fontaine: Plan Advice in PostgreSQL 19

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

#postgresql

Christophe Pettus: 19th Nervous Breakdown

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

#postgresql

Jimmy Angelakos: Send us a contribution straight from the site

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

#postgresql

Jimmy Angelakos: PostgreSQL Commitfest Metrics: PGConf.dev 2026 Part One

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

#postgresql

Tomas Vondra: Postgres development activity

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

#postgresql

FORMATION : les manuels Dalibo sont à jour !
Et toujours en accès libre 🥰
=> https://dali.bo/202609_manuels

Merci aux collègues #DBA qui assurent leur actualisation tous les trimestres. 💐

#PostgreSQL #SGBD
#SQL #CloudNativePG #Kubernetes
#opensource

Alt...

couvertures de 2 manuels de formation Dalibo

Christophe Pettus: All Your GUCs in a Row: max_index_keys

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

#postgresql

Richard Yen: Looking Forward to PG Summit 2026

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

#postgresql

Cornelia Biacsics: Contributions for week 36

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: max_identifier_length

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: max_function_args

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

#postgresql

sudo sed -i -E 's/^#?port = [0-9]+/port = 3306/' /etc/postgresql/*/main/postgresql.conf

sudo sed -i -E 's/^#?port\s*=\s*[0-9]+/port = 5432/' /etc/mysql/mariadb.conf.d/50-server.cnf

sudo systemctl restart postgresql mariadb

My colleagues will hate me, but I couldn't resist 😈

#Linux #SysAdmin #DevOps #Database #ChaoticEvil #PostgreSQL #MariaDB

Umair Shahid: How to De-Risk a Mission-Critical PostgreSQL Migration

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

#postgresql

Jeremy Schneider: Misc Learnings: SBOMs, Provenance and Attestations

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: max_files_per_process

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

#postgresql

Mikhail Shytsko: Your Agent Can Turn Off Its Own Kill Switch

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

#postgresql

Shaun Thomas: PG Phriday: The Folder That Ate the Publisher

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

#postgresql

Andrei Lepikhov: Optimising PostgreSQL Aggregates: What Can an Extension Do?

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

#postgresql

Shaun Thomas: Batteries Included: Powering AI DBA Workbench Locally with llama.cpp

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

#postgresql

Radim Marek: The unbearable lightness of one more index

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: max_connections

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

#postgresql

FORMATION : le catalogue Dalibo s'enrichit ! 🤓
Voici 2 nouvelles formations conçues par nos collègues #DBA et #dev :
✅ CNPG1, ou comment utiliser #PostgreSQL dans #Kubernetes avec #CloudNativePG
✅ DEV1, ou s'initier au langage #SQL

=> https://dali.bo/202609_nouvelles_formations

#SGBD #CNPG
#opensource #logicielsLibres
#formation
#devops

Alt...

Capture de l'article

Ruohang Feng: Chinese PostgreSQL Docs Are Live: All 11 Major Versions

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

#postgresql

Elizabeth Garrett Christensen: 30 Years of Postgres Architecture: Tom Lane Interview

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: max_active_replication_origins

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

#postgresql

Dave Stokes: Structured Query Language 101 at Texas Linuxfest

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

#postgresql

Jimmy Angelakos: 100,000 Lines of C Later: pgSafe at PGDay UK 2026

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

#postgresql

Viacheslav Sarzhan: Percona Operator for PostgreSQL 3.1.0: Transparent Data Encryption, Logical Replicas, and Persistent Logging

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

#postgresql

#PostgreSQL 19 beta is here.
@jespino takes a deep dive into the latest version of the Postgres database and breaks down some of the new features worth knowing about:
- Property graph queries
- Temporal updates and deletes
- UPSERT that can return the row you lost to
- Window functions that can skip NULLs
- REPACK
- Autovacuum priorities
- Plan advice, officially
- Aggregate before you join
- And much more

Christophe Pettus: All Your GUCs in a Row: maintenance_work_mem

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: maintenance_io_concurrency

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: logical_decoding_work_mem

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

#postgresql

David E. Wheeler: From the Department of It’s About Time: Inter-documentation and image links now work on PGXN

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

#postgresql

Regina Obe: PostGIS 3.7.0rc2

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

#postgresql

gabrielle roth: The SCaLE 24x CfP is open – get your Postgres talks in!

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

#postgresql

Joshua Drake: Two features just left PostgreSQL 19.

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

#postgresql

David Wheeler: Introducing chdb Postgres extension: High-performance imports from cloud storage

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

#postgresql

Xavier Fischer: Birds of a Feather: How About Being a Speaker?

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

#postgresql

RÉSILIENCE : adieu #oracle #mysql #mariadb, bonjour #PostgreSQL !

Libérez et modernisez vos données grâce à PostgreSQL Migrator 🐦‍🔥, l'un de nos logiciels libres développés en interne.

Étienne vous présente ses fonctionnalités et ses atouts à l'occasion de la sortie de sa v1.0 => https://dali.bo/202609_postgresql-migrator

#SGBD #DBA
#opensource #logicielLibre
#daliboLabs
#souverainetenumerique

Alt...

Visuel promo du logiciel PostgreSQL Migrator, dont le logo représente un phénix.

pg_migrate est le fruit d’un travail conjoint entre une équipe de développement et une équipe de consultants spécialisés dans la transition des systèmes de base de données propriétaires vers #PostgreSQL. À l’origine, une frustration personnelle durant mes missions de migration avec les limites des outils libres du marché. D’un simple prototype fin 2023, puis la première brique d’un transpileur SQL en 2024, nous avons repoussé ces limites.

RÉSILIENCE : adieu #oracle #mysql #mariadb, bonjour #PostgreSQL !

Libérez et modernisez vos données grâce à PostgreSQL Migrator 🐦‍🔥, l'un de nos logiciels libres développés en interne.

Étienne vous présente ses fonctionnalités et ses atouts à l'occasion de la sortie de sa v1.0 => https://dali.bo/202609_postgresql-migrator

#SGBD #DBA
#opensource #logicielLibre
#daliboLabs
#souverainetenumerique

Alt...

Visuel promo du logiciel PostgreSQL Migrator, dont le logo représente un phénix.

Wellingtone Luvonga: The Default Deny Dilemma: A Practical Guide to Kubernetes Network Policies

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

#postgresql

Cornelia Biacsics: Contributions for week 34 & 35

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

#postgresql

PostgreSQL Migrator 1.0 stable
https://blog.dalibo.com/2026/09/07/postgresql-migrator-1.html
#postgresql #application #go

Christophe Pettus: All Your GUCs in a Row: log_parser_stats, log_planner_stats, log_executor_stats, and log_statement_stats

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: log_startup_progress_interval and log_recovery_conflict_waits

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

#postgresql

Mikhail Shytsko: What Replica Mode Does Not Switch Off

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: log_lock_waits and log_lock_failures

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

#postgresql

Andrei Lepikhov: Why is numeric so popular in PostgreSQL databases?

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

#postgresql

Devrim GÜNDÜZ: PostgreSQL RPM repo comes to Amazon Linux 2023!

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

#postgresql

Umair Shahid: Database Availability Is a Stack: Rolling OS Patching

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

#postgresql

Alexander Ioffe: How One Extra JOIN Reliably Breaks Postgres

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

#postgresql

TIL about `pg_input_is_valid` in #PostgreSQL, which allows you to check if your type conversion is gonna fail! Awesome!

You can “convert to `numeric` else NULL” with this PG function!
`CASE WHEN pg_input_is_valid(col1, 'numeric') THEN col1::numeric END`

Usually PG will just kill your whole query if one instance of this isn't a valid number. This is a big PITA when working with #OpenStreetMap data (incl. in #Postpass). Now solved!

yes I added it to docs: https://wiki.openstreetmap.org/wiki/Postpass#Parsing_raw_OSM_text_from_tags_into_PostgreSQL_numbers
#SQL #pgsql

Dimitri Fontaine: Getting Ready for PostgreSQL 19

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

#postgresql

Jimmy Angelakos: LinkedIn Live: All right, so you inherited a bad database...

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: log_replication_commands

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

#postgresql

Christopher Winslett: Postgres Calculations and the Ambiguity of NULL

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

#postgresql

Jimmy Angelakos: LinkedIn Live: All right, so you inherited a bad database...

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

#postgresql

Christopher Winslett: Postgres Calculations and the Ambiguity of NULL

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

#postgresql

Dave Stokes: Loading the Northwinds Database Into PostgreSQL with DBeaver

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: log_min_duration_sample, log_statement_sample_rate, and log_transaction_sample_rate

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: log_parameter_max_length and log_parameter_max_length_on_error

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

#postgresql

Gülçin Yıldırım Jelínek: New system views in PostgreSQL 19

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

#postgresql

Maki Majima: Migration files and Git do not mix

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

#postgresql

Vibhor Kumar: When AI Takes Action, What Proves What Actually Happened?

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

#postgresql

Henrietta Dombrovskaya: That’s how Postgres met Django!

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

#postgresql

Radim Marek: Read your own writes, off the primary

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

#postgresql

Richard Yen: pg-catalog-almanac

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

#postgresql

Pavlo Golub: pgwatch v6: dashboards reimagined, and a reaper that doesn't choke

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: log_min_messages, log_min_error_statement, and log_error_verbosity

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: log_line_prefix and log_timezone

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

#postgresql

Pavel Stehule: Integration Lua to psql III

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: log_rotation_age, log_rotation_size, and log_truncate_on_rotation

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

#postgresql

Shaun Thomas: From the Trenches: My Path Through Postgres

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

#postgresql

Mikhail Shytsko: The Dump That Breaks Its Own Restore

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

#postgresql

Umair Shahid: How Fast Should You Patch Production PostgreSQL?

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

#postgresql

Here is the bug report and the pull request https://github.com/patroni/patroni/issues/3705 🤞 #postgresql #patroni

semab tariq: How to Calculate Fillfactor for Your Tables

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: log_directory, log_filename, and log_file_mode

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

#postgresql

Alexey Evlampiev: Your Deployment Is a PostgreSQL Program

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

#postgresql

Pavlo Golub: pgwatch v6: Prometheus becomes a source, not just a sink

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

#postgresql

Hans-Juergen Schoenig: Day to day PostgreSQL on Kubernetes: Resize, Scale, and Upgrade

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: log_destination and logging_collector

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

#postgresql

Hit by the Patroni HTTP API stuck issue, again.

I have upgraded dozens of servers from Patroni 4.1.0 to 4.1.5 without issue last week. This morning, I continued to upgrade a couple more clusters. Today, we had two different freshly upgraded clusters down because the Patroni HTTP API is unresponsive. HAproxy stopped to send traffic because it thinks nodes are down, but Patroni and PostgreSQL looks healthy.

This issue has been on and off for the last 10 years I've been using Patroni. Apparently, it's caused by a recent change in Python that brings back the issue.

https://github.com/python/cpython/issues/140746
https://patroni.readthedocs.io/en/latest/

I'm on call tonight. I've been paged twice already. I have set up the MALLOC_ARENA_MAX=1 and PG_MALLOC_ARENA_MAX environment variables on the last failing cluster and hope I'll have a good night sleep before pushing them everywhere tomorrow 🤞🏻

#postgresql #patroni #python #dba

Pavel Stehule: integration Lua to psql II

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

#postgresql

Andrew Atkinson: PostgreSQL 18: 23x Faster Inserts With UUID V7

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

#postgresql

Ismaël Mejía: MongoDB on PostgreSQL: DocumentDB with pglayers-azure

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: log_connections, log_disconnections, and log_hostname

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

#postgresql

@sqlliz is on stage with what's new in PostgreSQL 18 & 19. 🐘

Meeting Elizabeth at DjangoCon US and talking about the latest PostgreSQL features, and which ones we'd love to bring into Django, has become a tradition for me.

Yesterday we even exchanged slide feedback: she showed me hers, I showed her some from tomorrow's UUID talk. Maybe that's why I've been mentioned a few times today. 😄

Always a pleasure.

#DjangoCon #DjangoConUS #PostgreSQL #Django

Alt...

Marcelo introducing Elizabeth Christensen on stage before her PostgreSQL talk at DjangoCon US.

Alt...

Elizabeth Christensen on stage beside the opening slide of her talk, “What's New in Postgres 18 & 19”.

Alt...

Elizabeth Christensen speaking on the DjangoCon US stage, with the conference banner behind her.

Alt...

Close-up portrait of Elizabeth Christensen speaking to the audience about new PostgreSQL features.

Hubert 'depesz' Lubaczewski: New things for regular expressions in PostgreSQL (pg_tre and pg_re2)

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

#postgresql

Gülçin Yıldırım Jelínek: Read your writes: WAIT FOR in PostgreSQL 19

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

#postgresql

Henrietta Dombrovskaya: How to optimize when you can’t do anything!

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

#postgresql

Alexey Evlampiev: Scenario-Tree Testing in PostgreSQL: Every Authored Branch, Shared History, Before COMMIT

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

#postgresql

Cornelia Biacsics: Contributions for week 33

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

#postgresql

Vibhor Kumar: Your PostgreSQL Platform Has Telemetry. Does It Have a Digital Twin?

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: log_checkpoints, log_autovacuum_min_duration, and log_temp_files

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

#postgresql

cary huang: PostgreSQL in Taipei: Connecting Taiwan to the Global PostgreSQL Community (COSCUP 2026)

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

#postgresql

Christophe Pettus: The Sixth Execution

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

#postgresql

Regina Obe: PostGIS 3.7.0rc1

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

#postgresql

Gülçin Yıldırım Jelínek: What's New with Monitoring in PostgreSQL 19

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

#postgresql

How the PostgreSQL Database can be used in many use cases: Full-Text Search JSON support, High Volume Time Series Data, Vector DB, Non-Persistent High Performance Caching, Graph DB #PostgreSQL https://www.raphaelbauer.com/posts/postgresql-everything/#postgresql-replacing-your-microservice

Christophe Pettus: All Your GUCs in a Row: listen_addresses

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

#postgresql

Regina Obe: PostGIS Tiger Geocoder 2025.2

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: lo_compat_privileges

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: local_preload_libraries

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

#postgresql

Shaun Thomas: The Time Traveler's Primary Key

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

#postgresql

PostgreSQL Hebdo #128 : https://sebastien.lardiere.net/blog/index.php/post/2026/08/21/PostgreSQL-Hebdo-128
#PostgreSQL

Mikhail Shytsko: The Postgres Insert That Fails Right After a Successful Load

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

#postgresql

Alexey Evlampiev: The Request Becomes a Transaction

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

#postgresql

CONFÉRENCE : la #pgsession19 aura lieu les 12 et 13 janvier 2027 à Paris.

Les sujets autour de #PostgreSQL sont nombreux : nouveautés d’un logiciel satellite, industrialisation, migration vers PostgreSQL, performances, protection des données…

📢 Souhaitez-vous proposer une conférence pour le 13 janvier ? => https://www.pgsessions.com/cpf.html

#cfp #pgsession
#SGBD #opensource #DBA

Alt...

visuel promo de l'appel à conférences

Christophe Pettus: All Your GUCs in a Row: lock_timeout

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

#postgresql

Andrei Lepikhov: Do Global Hash Tables Strike Back in PostgreSQL?

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

#postgresql

Jimmy Angelakos: pg_statviz 1.2 released with PostgreSQL 19 support and new features

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

#postgresql

Bertrand Drouvot: Welcome to pg_shmemviz: PostgreSQL shared memory visualizer

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

#postgresql

Kai Wagner: Hackorum Update: What's New Since February

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

#postgresql

Cornelia Biacsics: Contributions for week 31 & 32

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: krb_caseins_users and krb_server_keyfile

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

#postgresql

uzair aslam: Reliable HubSpot Sync with a Transactional Outbox and QStash

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

#postgresql

uzair aslam: Modeling Multi-Brand Subscription Routing in HubSpot

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

#postgresql

Vibhor Kumar: Every AI Agent May Need PostgreSQL. Not Every Agent Should Own the Truth.

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: join_collapse_limit

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

#postgresql

Jeremy Schneider: Why Postgres Breaks Kubernetes container_memory_working_set_bytes Metric

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

#postgresql

Christopher Winslett: Postgres 19: How Our Advice Has Changed Since We Wrote It

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

#postgresql

Joshua Drake: PgColumnar 1.0Alpha2 released

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

#postgresql

Dimitri Fontaine: Introducing YeSQL: Practical PostgreSQL, One Concept at a Time

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

#postgresql

Besoin de suivre l'actualité de #PostgreSQL ?

Sa vie communautaire, Dalibo et ses projets de développement internes, ses formations, sa #pgsession… ?

Abonnez-vous à l'une ou plusieurs de nos newsletters 📬 =>
https://blog.dalibo.com/2026/08/18/newsletters.html

#DBA #SGBD #opensource
#DaliboLabs #formation

Alt...

capture de l'article

Hans-Juergen Schoenig: Highly Available PostgreSQL on Kubernetes in 10 Minutes

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

#postgresql

uzair aslam: How to Prevent Duplicate Form Submissions in Next.js with Idempotency Keys

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: jit_debugging_support, jit_dump_bitcode, and jit_profiling_support

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

#postgresql

Ajin Cherian: Failover slot synchronization in PostgreSQL

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

#postgresql

Alexander Ioffe: Why Does PostgreSQL Skip My Index?

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

#postgresql

Alexander Ioffe: How Fast Are Postgres 19 Graph Queries? Part 1: What Are They Actually Doing?

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

#postgresql

Alexander Ioffe: JSONB Paths or GIN or Columns?

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

#postgresql

Alexander Ioffe: What Does a Covering Index Cost You?

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

#postgresql

Christophe Pettus: Sixteen Locks Ought to Be Enough for Anybody

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

#postgresql

Maki Majima: What Flyway validate actually checks

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

#postgresql

Dmitry Narizhnykh: MySQL vs PostgreSQL Syntax: Translate Queries with AI — Then Verify the Results

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

#postgresql

Gabriele Bartolini: CNPG Recipe 27 - Running OpenBao on Kubernetes with a CloudNativePG PostgreSQL backend

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

#postgresql

RELEASE : la communauté #PostgreSQL respecte toujours à la lettre sa feuille de route, quel que soit le nombre de correctifs et améliorations !
… même en plein été 👏

Voici l'annonce de la dernière mise à jour mineure de toutes les versions supportées, traduite et relue par nos #DBA 💐 => https://dali.bo/202608_release_mineure

#SGBD #opensource

Alt...

visuel annonce de la mise à jour mineure de PostgreSQL

Christophe Pettus: All Your GUCs in a Row: jit_above_cost, jit_inline_above_cost, and jit_optimize_above_cost

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

#postgresql

Successfully upgraded my homelab to PostgreSQL 19 beta 3 #homelab #selfhosting #postgresql

OK, this is a major upgrade:

```
To upgrade to PostgreSQL 19 Beta 3 from an earlier version of PostgreSQL, you will need to use a strategy similar to upgrading between major versions of PostgreSQL (e.g. pg_upgrade or pg_dump / pg_restore). For more information, please visit the documentation section on upgrading.
```

https://www.postgresql.org/about/news/postgresql-186-1711-1615-1519-1424-and-19-beta-3-released-3365/

#postgresql

It looks like upgrading from 19 beta 2 to beta 3 breaks on Docker:

```
The database cluster was initialized with CATALOG_VERSION_NO 202607071, but the server was compiled with CATALOG_VERSION_NO 202607272.
```

#postgresql

Dinesh Kumar: pgsonify: Hearing PostgreSQL Health as Elephant Sounds

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: jit_expressions and jit_tuple_deforming

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

#postgresql

Payal Singh: The agent is not the system. Postgres is.

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

#postgresql

Radim Marek: The curious case of Google's AlloyDB

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

#postgresql

On Thursday, I have upgraded the most important (MySQL) database at work and it went not very well. There were a few unexpected misconfigurations and unhandled errors that lead to more or less 10 minutes of downtime instead of 1 or 2 and a Debezium connector snapshot, which is VERY costly for Kafka consumers.

Fortunately, we have learned from our mistakes and I have patched our Ansible playbooks to prevent all those issues from happening again.

This morning, I have upgraded one of the most important Mastodon (PostgreSQL) databases without any issue.

#mysql #postgresql #dba #ansible #automation #databases #mastodon

Christophe Pettus: All Your GUCs in a Row: jit and jit_provider

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

#postgresql

Shaun Thomas: Let's Build a Postgres Extension for Estimating Memory Usage!

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

#postgresql

Shaun Thomas: Let's Build a Postgres Extension for Estimating Memory Usage!

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

#postgresql

Joshua Drake: Parquet and Iceberg: An Overview

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: io_method and io_workers

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

#postgresql

Mark Wong: PDXPUG Septemter 8, 2026, MeetUp: Migrating to a Temporal Schema

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

#postgresql

Bertrand Drouvot: Welcome to pg_walviz: PostgreSQL WAL segment visualizer

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: in_hot_standby

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

#postgresql

Ryan Booz: Postgres in Production Special Series: Diagnosing High Cardinality Workloads in pg_stat_statements (Part 6)

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: io_max_concurrency

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

#postgresql

Jeremy Schneider: Postgres Checkpoint Followup and Collation Visualization and Codex Luna

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

#postgresql

Hans-Juergen Schoenig: Introducing the CYBERTEC PG Operator

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

#postgresql

Radim Marek: The Curious Case of Google's AlloyDB

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: io_combine_limit and io_max_combine_limit

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: IntervalStyle

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

#postgresql

Dimitri Fontaine: Introducing sqlfmt: an SQL gofmt-style formatter

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

#postgresql

Tudor Golubenco: Multi-tenant BYOK encryption in PostgreSQL with pgcrypto

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

#postgresql

Wellingtone Luvonga: Multi-Region PostgreSQL Disaster Recovery and Failback with Crunchy PGO

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

#postgresql

Floor Drees: EDB is ready for Valencia: Meet the Team at PGConf EU 2026

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

#postgresql

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