POSETTE Talk Recap - Postgres Isn't Slow. Your Storage Is

https://clickhouse.com/blog/posette-talk-recap-postgres-isnt-slow-your-storage-is

#PostgreSQL

Devrim GÜNDÜZ: PostgreSQL RPM repository meets AI with pg_statviz

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

#postgresql

Devrim GÜNDÜZ: PostgreSQL RPM repository meets AI with pg_statviz

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

#postgresql

Cornelia Biacsics: Contributions for week 40

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: password_encryption

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: plan_cache_mode

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

#postgresql

David Wheeler: PGConf.EU Community Day: A Postgres Ecosystem Foundation?

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

#postgresql

Radim Marek: How TABLESAMPLE picks rows

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

#postgresql

Chris van Eijk: infinite recursion detected in policy: causes and fixes

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

#postgresql

Random Mastodon admin question (or maybe someone else has done this)... anyone here who has set up a Postgresql hot standby/read replica who might answer a few questions or lend some prior experience?

(looking to create a replica of an existing Mastodon database, on another server -- already all set up -- and just looking for some gray hair/experience on what to avoid and what does/does not work. Trying to start replicating an existing server from the cloud to a local ISP, with plans to eventually fail over to a new install... need to scale my server here up and NOT on a certain cloud provider that charges egress).

#MastoAdmin #postgresql

Christophe Pettus: All Your GUCs in a Row: parallel_setup_cost and parallel_tuple_cost

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: parallel_leader_participation

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

#postgresql

Chris van Eijk: new row violates row-level security policy: the causes

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

#postgresql

Chris van Eijk: One partition per tenant in PostgreSQL, measured

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

#postgresql

Álvaro Hernández: Scaling Citus without limits: announcing Query Routers in StackGres

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

#postgresql

Shaun Thomas: PG Phriday: Against the WAL

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

#postgresql

Christophe Pettus: Portions Copyright

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

#postgresql

SHRIDHAR KHANAL: The Database Restarted Without Restarting: The Basics of PostgreSQL Signals (Part 1)

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

#postgresql

Hollis Varden: Five PostgreSQL queries that did more work than I asked for

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

#postgresql

Hollis Varden: UUIDs stored as text: what it costs in PostgreSQL 18

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

#postgresql

Peter Eisentraut: The reverts will continue until morale improves

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

#postgresql

Radim Marek: Postgres relation files, filed under base/

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: array_nulls (Special Update)

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

#postgresql

Kaarel Moppel: An OLTP perf check on Postgres 19 Beta 3.5

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

#postgresql

Andrei Lepikhov: Why is PostgreSQL's Numeric Type so Slow?

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

#postgresql

Christophe Pettus: The International Ice Patrol

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

#postgresql

what features does prostgres offer that sqlite doesn't? i know that the former is a server and the latter is local, that's besides the point here. only SQL features and extensions, please.

asking for a friend.

#postgres #postgresql #sqlite

Igor Suhorukov: Vectorized Query Execution in PostgreSQL 19: Arrow, ORCA and Flight SQL in a PostgreSQL Extension

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: num_os_semaphores

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

#postgresql

Chris van Eijk: Counting per tenant in PostgreSQL: count, estimate, counter

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

#postgresql

Christophe Pettus: The Deep End

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

#postgresql

Prateek Arora: I timed 179 index recommendations on real data. 18% made the query slower.

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

#postgresql

Dimitri Fontaine: Consolidating databases with Postgres logical replication

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: notify_buffers

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

#postgresql

Igor Suhorukov: Greenplum without the fork: Apache Cloudberry as PostgreSQL 19 Extensions

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

#postgresql

Alexander Ioffe: I ran the same query twice and Postgres disagreed with itself

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

#postgresql

Christophe Pettus: Everyone into the Pool

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

#postgresql

Christophe Pettus: The Vector That Lied About Its Dimensions

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

#postgresql

Cornelia Biacsics: Contributions for week 39

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

#postgresql

Kaushik Iska: What is direct I/O, and why does ClickHouse Managed Postgres use it for backups?

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: multixact_member_buffers and multixact_offset_buffers

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

#postgresql

Chris van Eijk: Audit log per tenant in PostgreSQL: what a trigger costs

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: min_wal_size

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: min_parallel_index_scan_size and min_parallel_table_scan_size

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

#postgresql

Chris van Eijk: Job queues per tenant in PostgreSQL: the noisy neighbour

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

#postgresql

Christophe Pettus: Nobody Patches the Pooler

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: md5_password_warnings

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

#postgresql

Greg Nancarrow: How to integrate JFrog Artifactory with Fujitsu Enterprise Postgres

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

#postgresql

Ming Ying: PlanetScale Released Text Search and We Have a Lot to Say (Part I)

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

#postgresql

📢 APPEL À CONFÉRENCES !

Le #cfp de la #pgsession19 court jusqu'au 28 octobre minuit => https://dali.bo/2026_pgsession19_cfp

📆 L'événement aura lieu le 13 janvier 2027, à Paris.

Vous pouvez y participer en présentant un retour d'expérience, une démo, un témoignage utilisateur, une étude comparative, etc.

Sur un outil, ou des thèmes comme la migration, l'industrialisation, la performance, la sauvegarde, etc.

Pourvu que cela concerne #PostgreSQL. 🥰

#SGBD #DBA
#opensource
#conférence

Alt...

Visuel promo de l'appel à conférences

Jimmy Angelakos: PostgresEDI September 2026 Meetup Recap: tiering to Iceberg, and Postgres from Nuxt

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

#postgresql

Tomas Vondra: Are we reverting patches because of bugs found by AI?

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

#postgresql

Chris van Eijk: Row-level security performance in PostgreSQL, measured

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

#postgresql

Chris van Eijk: PgBouncer and RLS: tenant context, SET LOCAL, shared plans

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: max_wal_size

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

#postgresql

Elizabeth Garrett Christensen: Query Plan Hints in PostgreSQL 19: How & When to Use Advice

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

#postgresql

David Wheeler: pg_clickhouse & chdb updates: Encoding, nesting, and types

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

#postgresql

Vik Fearing: A Hint of Dependence

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

#postgresql

The Schema Registry issue was related to the TimescaleDb SMT not routing correctly so the subjects were starting with an underscore and that is not allowed.

Meanwhile, we have an issue with MySQL connectors failing with EOFException while parsing binlogs. This bug has been fixed 3 weeks ago https://github.com/debezium/dbz/issues/2611

That new release of Debezium will solve a lot of our issues!

#debezium #cdc #postgresql #timescaledb #mysql

Devrim GÜNDÜZ: Rust extensions started landing PostgreSQL RPM repository

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

#postgresql

Dinesh Kumar: ALTER FUNCTION SET work_mem: Fixing PostgreSQL Disk Spills Without a Global Change

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: max_wal_senders

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

#postgresql

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.

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

One last server build to support #atomdrift before I run out of money (256GB of DDR5 does not come cheap!). With any luck, this will provide enough #PostgreSQL muscle to keep the lights on for the next year:

AMD Ryzen 9950X3D2 / 256GB RAM / Intel Optane 900P / 2x7.68TB Kioxia CD8

As for the OS - perhaps #NixOS?

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.
```