Dinesh Kumar: How to Reduce PostgreSQL Memory Usage and Cut Your Cloud Bill in Half

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

#postgresql

Jianghua yang: Pricing plans in PostgreSQL's currency: pg_orca's PG-aligned cost model

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

#postgresql

Minor upgrades are no longer a thing #postgresql

Cool, I didn't expect an ABI change in the last MINOR release of the Debian packaging of the PostgreSQL packages.

We don't pin most of the extensions, like ip4r, partman, vector, etc, so a reinstall of a server that is not running on the very last minor release breaks, on a Friday.

At the same time, we found out that our old version of TimescaleDB broke compatibility with the last PostgreSQL MINOR releases.

OK, it's Friday, 6:00 pm. Time to go off.

#postgresql #dba #friday #upgrades

Jeremy Schneider: Postgres 18.7 Debian and Redhat Packagers Protect You

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

#postgresql

PostgreSQL Hebdo #129 : https://sebastien.lardiere.net/blog/index.php/post/2026/11/13/PostgreSQL-Hebdo-129
#PostgreSQL

Andrew Dunstan: Announcing Release 22 of the PostgreSQL Buildfarm client

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

#postgresql

RELEASE : la communauté #PostgreSQL a annoncé hier la mise à jour de toutes les versions supportées, ainsi que la release candidate de PostgreSQL 19. Bravo à elle pour sa constance. 💐

Voici la traduction de nos collègues #DBA => https://dali.bo/202611_release

#SGBD #opensource
#update #upgrade

Alt...

visuel d'annonce de release mineure

Ruohang Feng: PostgreSQL Just Patched 52 CVEs in a Single Minor Release

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

#postgresql

Ruohang Feng: PostgreSQL Ate the Database World. Now the Giants Are Eating Postgres Companies.

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

#postgresql

Greg Nancarrow: Build resilient AI workflows with DBOS and Fujitsu Enterprise Postgres

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

#postgresql

Lukas Fittl: Postgres 18.7 Security Release: The Impact of CVE-2026-6460 & other memory corruption issues

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

#postgresql

Jeremy Schneider: Postgres 18.7 minor breaks ABI compatibility again

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

#postgresql

Jimmy Angelakos: Community Over Code Glasgow 2026 and a ColdFront lightning talk

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

#postgresql

Every practical lesson of the SQL course on sqltest.online now has a PostgreSQL task 🐘

82 tasks on the Bookings flight database (flights, airports, tickets, seats): from SELECT and JOINs through CTEs and window functions to the new ones on INSERT, UPDATE, DELETE, transactions, CREATE TABLE, views and indexes.

DML and DDL tasks change real data: each run gets its own sandbox copy.

https://sqltest.online/en/database/bookings

#PostgreSQL #SQL #LearnSQL #Database

Alt...

PostgreSQL practice on sqltest.online: 82 SQL tasks on the Bookings database for every practical lesson of modules 2-10, from SELECT to indexes, plus a sample transaction with two UPDATE statements between BEGIN and COMMIT.

Mehmet Ince: Part 3/6 | How I Ended Up Turning a 22-Year-Old PostgreSQL Type-Confusion Primitive into RCE (CVE-2026-6460)

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

#postgresql

#PostgreSQL 18.7, 17.12, 16.16, 15.20, 14.25, and 19 RC 2 Released! https://www.postgresql.org/about/news/postgresql-187-1712-1616-1520-1425-and-19-rc-2-released-3442/

Devrim GÜNDÜZ: PostgreSQL November 2026 minor releases: update the server and extensions together

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

#postgresql

uzair aslam: Vercel Cron Jobs in Production: Secure, Retry-Safe Jobs with Next.js

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

#postgresql

uzair aslam: PostgreSQL Vector Search with pgvector: Hybrid Search in Next.js

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

#postgresql

Christophe Pettus: Stop Using AI to Report PostgreSQL Bugs

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

#postgresql

Munaf Khatri: Testing: Auto-generated Unit, Integration and Data leakage tests for PostgreSQL, Supabase and Neon

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

#postgresql

Umair Shahid: Life After PostgreSQL 14

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

#postgresql

PostgreSQL Berlin November 2026 Meetup

https://andreas.scherbaum.la/post/2026-11-11_postgresql-berlin-november-2026-meetup/

#PostgreSQL #Meetup #Berlin

Andreas Scherbaum: PostgreSQL Berlin November 2026 Meetup

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

#postgresql

In the latest article in the @adminmagazine #SelfHosting series, @makkes shows you how to install and configure your own Matrix homeserver with Synapse

https://www.admin-it.io/running-your-own-matrix-server-with-synapse/?utm_source=mlm

@element @matrix #Synapse #homeserver #messaging #PostgreSQL #OpenID #encryption #backup #security

Alt...

Diagram of a Minimal Matrix Setup

Radim Marek: B-tree pages, sorted and sparse

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

#postgresql

Mats Kindahl: Building a Table Access Method, Part 8: Cache invalidation

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

#postgresql

Vibhor Kumar: Beyond AI Buzzwords: Four Questions Every Enterprise Leader Must Answer

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

#postgresql

Got this cool t-shirt from Cornelia Biacsics at pgconf.eu 2026 in València. Thank you!

#PostgreSQL #PGConfEU

Alt...

A t-shirt saying "You're not using PostgreSQL?" on the front, the text is white and blue, and the "?" is worked into the outline elephant

Alt...

A t-shirt saying "Please Explain Yourself." on the back

RELEASE : notre solution-maison pour migrer vos données continue de s'améliorer.
#PostgreSQL Migrator 1.3.0 vient de sortir, avec le support de #MySQL 5.7. Bravo à nos collègues mainteneurs ! 😊
=> https://postgresql-migrator.readthedocs.io/en/latest/references/CHANGELOG/#130

#daliboLabs #SGBD #DBA
#opensource
#resiliencenumerique

Alt...

visuel promo de PostgreSQL Migrator

Laurenz Albe: Don't dream it, be it!

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

#postgresql

Hubert 'depesz' Lubaczewski: What LLMs do to PostgreSQL and DBAs

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

#postgresql

Richard Yen: An Index Scan Is Only Half the Story

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

#postgresql

Cornelia Biacsics: Contributions for week 44

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

#postgresql

Maki Majima: Two migrations collide: one loud failure, one silent one

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

#postgresql

Chris van Eijk: json vs jsonb in PostgreSQL: size and speed, measured

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

#postgresql

I still need something to do, so if you're looking for a software developer with 20-or-so years #Perl #PostgreSQL experience in EU/EEA, I'm all ears.

I've dabbled with Plack, Moo, Mojo, AnyEvent, Gtk, and a few other things; my job for 17 years was making call centre software and my last for 1.5 years was in domains. I'm poking around in newer languages on Exercism, can do some Ruby, Python and seen C and JS before. Speak hu en de nl and a little ja.

#GetFediHired #FediHire #LookingForWork

Mats Kindahl: Building a Table Access Method, Part 7: Storing and reading rows

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

#postgresql

Vadim Yatsenko: The Server-First Reader Pool: Exact Connection Reuse and Hot-Path Performance

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

#postgresql

Hollis Varden: Thirteen small measurements on PostgreSQL 18

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

#postgresql

GitLab is hiring Intermediate Software Engineer, Security Factory: Vulnerability Management

🔧 #javascript #ruby #rubyonrails #vue #elasticsearch #postgresql #securityengineer
🌎 Remote; Canada; Israel; United Kingdom; United States
⏰ Full-time
🏢 GitLab

Job details https://jobsfordevelopers.com/jobs/intermediate-software-engineer-security-factory-vulnerability-management-at-gitlab-com-aug-20-2026-0cfbc0?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring

Ruohang Feng: PostgreSQL Ecosystem Update: The AI Bug-Hunting Crunch

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

#postgresql

Ruohang Feng: Taking Over Another PostgreSQL Extension: vchord Yesterday, pg_mooncake Today

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

#postgresql

Dave Stokes: Is PostgreSQL Really Winning Part 2: The Evidence Beyond the Rankings

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: scram_iterations

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

#postgresql

Chris Travers: PostgreSQL, NUMA, and the Cloud

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

#postgresql

ÉVÉNEMENT : le programme des conférences de la #pgsession19 sort ce matin.

👉 Les sujets tournent autour de la sécurité des données, l'observabilité, ainsi que la communauté #PostgreSQL… des conditions favorisant l'autonomie numérique des organisations utilisant le #SGBD libre.

📆 La journée Conférences aura lieu le 13 janvier 2027 à Paris. Inscrivez-vous dès aujourd'hui => https://dali.bo/202611_pgsession19_conferences

#DBA #opensource #conférences

Alt...

visuel PGSession 19

Did you know that the beloved C64 can run the #PostgreSQL psql client?

The tool is called YellowedPlasticSQL, or short: ypsql

Daniel Gustafsson presented the project at #PGConfEU in #Valencia, earlier his year.

https://github.com/danielgustafsson/ypsql

Ruohang Feng: Why I'm Maintaining a VectorChord Fork

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

#postgresql

Nikolay Samokhvalov: UUIDv4 vs UUIDv7: what a random primary key costs in Postgres

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

#postgresql

Jimmy Angelakos: PGConf.EU 2026 MEGAPOST: a busy week in Valencia

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

#postgresql

Ahsan Hadi: Zero Downtime In-Place Major PostgreSQL Upgrades on a Distributed PostgreSQL Cluster

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

#postgresql

SHRIDHAR KHANAL: PostgreSQL Minor Version Upgrade on RHEL 9: A Step-by-Step Guide with Rollback

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

#postgresql

Bruce Momjian: New Presentation

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

#postgresql

PhotoPrism mit PostgreSQL und KI-Anbindung
https://linuxnews.de/photoprism-mit-postgresql-und-ki-anbindung/

#Linux #LinuxNews #LinuxDE #LinuxNewsDE #EULE #EULEde #PhotoPrism #PostgreSQL #KI #OpenSource

Ilya Kosmodemiansky: The “default” postgresql.conf

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

#postgresql

Cornelia Biacsics: Contributions for week 43

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

#postgresql

Jimmy Angelakos: Postgres Edinburgh October 2026 Meetup Recap

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

#postgresql

Dave Stokes: Is PostgreSQL Really Winning?

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

#postgresql

Dimitri Fontaine: Postgres logical replication beyond one writer

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

#postgresql

Stefanie Janine: PostgreSQL Conference Europe Wrapup

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

#postgresql

Jimmy Angelakos: Establishing the PostgreSQL Standard: PGConf.dev 2026 Part Two

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

#postgresql

Magnus Hagander: Nordic PGDay 2027 - Sponsorships for Nordic PGDay 2027 Are Now Open

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

#postgresql

Gabriele Bartolini: CloudNativePG reaches CNCF Incubation: another rung on the ladder

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

#postgresql

👋 Hi, Mastodon! This is SQLtest.online, a free SQL trainer that runs in your browser.

• 480+ practice tasks with instant automatic checks
• Real database engines: PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, Firebird, DuckDB
• A step-by-step SQL course, a skills test and an interview simulator
• No install, no paywall, open source

Here we'll share new lessons, tasks and SQL tips. Questions welcome!

https://sqltest.online

#SQL #LearnSQL #PostgreSQL #MySQL #Database #Introduction

PostgreSQL 19 verzögert sich – KI findet viele Bugs

Die Veröffentlichung von PostgreSQL 19 könnte sich bis November 2026 verzögern.

https://www.linux-magazin.de/news/postgresql-19-verzoegert-sich-ki-findet-viele-bugs/

#linux #opensource #PostgreSQL

@uba

Alt...

Blaues Elefantenkopf-Logo mit schwarzer Kontur über dem Schriftzug „PostgreSQL“ in Schwarz und Blau auf weißem Hintergrund.

Vibhor Kumar: Autonomous Postgres at PGConf.EU 2026: From Scripts to Self-Driving, and the Primitives in Between

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

#postgresql

Aleksei Aleinikov: Navicat 18 Review: Is It Worth It for PostgreSQL? Tested on 10M Rows

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

#postgresql

Chris van Eijk: server closed the connection unexpectedly in PostgreSQL

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: row_security

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

#postgresql

Vadim Yatsenko: Splitting the Read-Only Transaction: Replica Reads Inside an Open Transaction

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: restrict_nonsystem_relation_kind

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

#postgresql

Radim Marek: Getting rid of a 4 TB table in PostgreSQL

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

#postgresql

Igor Suhorukov: pg_vexec one month on: ahead of ClickHouse on Parquet, close behind on MergeTree

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

#postgresql

Regina Obe: PostGIS 3.7.0

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

#postgresql

Shaun Thomas: Burnt TOAST

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

#postgresql

Robert Haas: Postgres 19 is late, and it's AI's fault

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

#postgresql

Munaf Khatri: Supabase is one part of your HIPAA compliance

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

#postgresql

Igor Suhorukov: Which language should an AI agent use to search its memory: SQL or SPARQL?

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

#postgresql

Vadim Yatsenko: Zero-Copy I/O for the Shared Storage Daemon: Removing the Last Copy from the WAL Path

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

#postgresql

Vadim Yatsenko: Read-Your-Writes at the Proxy: LSN Session Consistency for PolarDB

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

#postgresql

Nikolay Samokhvalov: Dump/restore done. Now what?

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: restore_command

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

#postgresql

Chris van Eijk: no pg_hba.conf entry for host: what it means, measured

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

#postgresql

Dinesh Kumar: SQL vs PL/pgSQL in PostgreSQL: Plan Caching

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

#postgresql

Mats Kindahl: Building a Table Access Method, Part 6: TRUNCATE

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

#postgresql

Aleksei Aleinikov: PostgreSQL Indexes: Which Type to Use (10M-Row Benchmark)

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: restart_after_crash

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: reserved_connections

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

#postgresql

having fun with #httpg #postgresql again. this plan visualizer is entirely written in sql! https://github.com/docteurklein/httpg/blob/8176253fc410528bd8bbbd58e37b86da3a48406d/schema/analyze/index.sql#L17

Alt...

a table showing details of a postgres execution plan

Devrim GÜNDÜZ: The PostgreSQL RPM repository needs a lot less EPEL now

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

#postgresql

Karen Jex: Fostering Inclusivity with the PostgreSQL Europe Diversity Committee

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

#postgresql

semab tariq: Your backups are green. That does not mean you can restore.

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

#postgresql

Vadim Yatsenko: Speech at PGDay Israel 2026：Durability, Consistency, and Performance

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

#postgresql

Vadim Yatsenko: DataMax: A Dedicated WAL Log-Store Node for Near-Synchronous Durability

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

#postgresql

Vadim Yatsenko: Commit Sequence Number (CSN) MVCC: Lock-Free Snapshot Acquisition

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: remove_temp_files_after_crash

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

#postgresql

Vadim Yatsenko: PolarFS: Disk-Paxos RW Leases That Keep Shared Storage Out of Split-Brain

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

#postgresql

Gabriele Bartolini: CNPG Recipe 28 - Generated and rotating PostgreSQL user passwords in CloudNativePG 1.31

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

#postgresql

Cornelia Biacsics: Contributions for week 41 & 42

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: recursive_worktable_factor

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

#postgresql

Henrietta Dombrovskaya: pg_acm at PGConf.EU

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

#postgresql

Ahsan Hadi: Zero Downtime Rolling Major PostgreSQL Upgrades on a Distributed PostgreSQL Cluster

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

#postgresql

Pavel Luzanov: PostgreSQL 19: part 5.4 (SQL, DEV1 and DEV2) of CommitFest 2026-03

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

#postgresql

Karen Jex: Tuning Postgres for Analytics - PGConf.EU

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

#postgresql

Igor Suhorukov: A knowledge base without a second database: Oxigraph’s SPARQL in PostgreSQL 19

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: the recovery_target parameters

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

#postgresql

Chris van Eijk: Supabase RLS policy examples, tested on PostgreSQL 17

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

#postgresql

Chris van Eijk: Supabase RLS policy not working? Ten causes, measured

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

#postgresql

Devrim GÜNDÜZ: PostGIS is back on Amazon Linux 2023 (with SFCGAL this time)

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

#postgresql

Muhammad Aqeel: Undo for Postgres, without losing the rest of your day

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

#postgresql

Umair Shahid: Your app does not need PostgreSQL superuser

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

#postgresql

Christophe Pettus: Binary read replicas in PostgreSQL, Part 3

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

#postgresql

Lætitia AVROT: Region : a lesson in data integrity

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

#postgresql

Ayoub Kazar: PostgreSQL as a graph database, part 1: SQL/PGQ in PostgreSQL

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

#postgresql

Ayoub Kazar: PostgreSQL as a graph database, part 0: intro, graphs, graph databases

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

#postgresql

Je tente une migration 14 vers 18, tout semblait ok, même si parfois un soucis réseau désactive la subscription je la relance et elle reprend, et à la "fin" toutes mes tables sont marqués "ready (r)" et pourtant… J'ai plusieurs tables vides à l'arrivée et toujours plein de "conflict=update_missing" et "Could not find the row to be updated." dans les logs, ce qui me fait penser qu'il y a un soucis que je ne comprend pas.

Est-ce que vous avez déjà eu à faire de telles migrations ? Vous avez eu ces soucis ? Vous avez des pistes pour moi ?

Le retoot me permettra de dormir mieux après ça !

#postgresql #adminsys

Christophe Pettus: All Your GUCs in a Row: recovery_prefetch

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

#postgresql

Chris van Eijk: Supabase RLS: when (select auth.uid()) helps, measured

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

#postgresql

Chris van Eijk: hstore vs jsonb performance in PostgreSQL, measured

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

#postgresql

Christophe Pettus: Binary read replicas in PostgreSQL, Part 2

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

#postgresql

ÉVÉNEMENT : en-dehors de nos sessions de formation de septembre à juin, nous vous proposons des ateliers à l'occasion de chaque #pgsession.

Cette année, cap sur la sécurité, l'autonomie et la performance, avec nos #dba et #développeurs.

La journée Ateliers de la #pgsession19 aura lieu le 12 janvier 2027 à Paris, avec une session animée en partenariat avec @camptocamp

Ouverture des inscriptions aoujoud'hui => https://dali.bo/202610_pgsession19_ateliers

#PostgreSQL #SGBD
#opensource

Alt...

visuel promo des ateliers PGSession 19

Igor Suhorukov: My PostgreSQL is faster than yours and has almost caught up with ClickHouse

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

#postgresql

Jeremy Schneider: Postgres recovery_prefetch Considered Harmful and Causing Outages

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

#postgresql

Regina Obe: PostGIS 3.7.0rc3

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

#postgresql

Chris van Eijk: idle in transaction in PostgreSQL: what it holds

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

#postgresql

Chris van Eijk: could not serialize access due to concurrent update

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: recovery_init_sync_method

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

#postgresql

Christophe Pettus: Binary read replicas in PostgreSQL, Part 1

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: recovery_min_apply_delay

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

#postgresql

Floor Drees: From a conversation to the CNPG Headlamp Plugin

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

#postgresql

Pavel Luzanov: PostgreSQL 19: part 5.3 (DBA3 and DBS) of CommitFest 2026-03

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: recovery_end_command

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

#postgresql

Chris van Eijk: unrecognized configuration parameter in PostgreSQL

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

#postgresql

Chris van Eijk: remaining connection slots are reserved in PostgreSQL

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

#postgresql

Devrim GÜNDÜZ: Every package in the PostgreSQL RPM repositories now has a page

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

#postgresql

Tom Kincaid: PostgreSQL 19: What Changed, What Matters, and What to Test Now

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

#postgresql

Vadim Yatsenko: Awide Labs open-sources Awide Polar: a PostgreSQL fork with compute-storage disaggregation and HTAP capabilities

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

#postgresql

Stefanie Janine Stölting: pgsql_tweaks Version 1.1.0 Released

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

#postgresql

TECH : lorsqu'une instance #PostgreSQL est déployée dans #kubernetes avec #CloudNativePG, le mécanisme d'éviction en cas de surconsommation mémoire change. Pierrick vous explique tout => https://dali.bo/202910_cnpg
🤓 ⚙️ 🔧

#SGBD #dba
#CNPG #K8S
#opensource

Alt...

capture de l'article

Chris van Eijk: invalid input syntax for type uuid in PostgreSQL, measured

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

#postgresql

Chris van Eijk: CREATE POLICY IF NOT EXISTS in PostgreSQL: what works

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

#postgresql

Hey ZFS folks: If I am running PostgreSQL 18, can I use an 8k recordsize on the dataset? What about the WAL directory? Does that stay in a separate dataset with a different recordsize or does it all go together?

Thanks so much!

Please boost for visiblity!

#FreeBSD #PostgreSQL #ZFS

Christophe Pettus: All Your GUCs in a Row: random_page_cost and seq_page_cost

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

#postgresql

Chris van Eijk: Rails, ActiveRecord and PostgreSQL RLS, measured

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

#postgresql

Chris van Eijk: stack depth limit exceeded in PostgreSQL: four causes

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: quote_all_identifiers

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

#postgresql

Chris van Eijk: TypeORM and PostgreSQL row-level security, measured

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

#postgresql

Chris van Eijk: Hibernate multi-tenancy and PostgreSQL RLS in Spring Boot

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

#postgresql

Andrew Atkinson: PostgreSQL in the 2026 Ruby on Rails Community Survey and Book Giveaways

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

#postgresql

Álvaro Hernández: Open-source Citus matches PlanetScale's Neki at 10M QPS on half the data nodes

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

#postgresql

Chris Travers: PostgreSQL 18 and libnuma

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

#postgresql

Pavel Luzanov: PostgreSQL 19: part 5.2 (DBA1 and DBA2) of CommitFest 2026-03

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

#postgresql

Dave Page: pgbuild, and Knowing What Ships with pgAdmin

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

#postgresql

Hubert 'depesz' Lubaczewski: Old tech is sometimes better – a case study based on blogpost from Now-Next…

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

#postgresql

Henrietta Dombrovskaya: Two Years of Community Building!

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: primary_slot_name

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

#postgresql

Chris van Eijk: A read-only user in PostgreSQL: what it can still do

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

#postgresql

Chris van Eijk: must be owner of table in PostgreSQL: who may alter it?

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

#postgresql

Dave Page: Moving the pgAdmin Build Farm to GitHub Actions

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

#postgresql

Devrim GÜNDÜZ: bigquery_fdw works again on every distribution we ship in the RPM repo

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

#postgresql

Tejaswi Thimmaiah: PostgreSQL Roles and Privileges Explained: A Practical RBAC Guide

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

#postgresql

Robert Haas: Hacking Workshop for November 2026

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

#postgresql

Christophe Pettus: A Parade of Horribles, in Serial Order

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

#postgresql

Floor Drees: PGConf.Asia 2026: EDB 발표 세션과 PostgreSQL 기술 인사이트

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

#postgresql

Floor Drees: Conference Preview: EDB at PGConf.Asia 2026

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: primary_conninfo

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

#postgresql

Chris van Eijk: Who bypasses row-level security in PostgreSQL? Measured

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

#postgresql

Chris van Eijk: ALTER DEFAULT PRIVILEGES not working? What we measured

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

#postgresql

Alexander Ioffe: Explain Analyze is a sample-size of One: Your query ran 1,100x faster the second time. It wasn't the cache.

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

#postgresql

Pavel Luzanov: PostgreSQL 19: part 5.1 (QPT) or CommitFest 2026-03

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: post_auth_delay and pre_auth_delay

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

#postgresql

Mayur B.: PGConf.EU 2026: Into the PostgreSQL Multiverse

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

#postgresql

Chris van Eijk: permission denied for table in PostgreSQL: which grant?

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

#postgresql

Chris van Eijk: current_setting and set_config in PostgreSQL, measured

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

#postgresql

Ming Ying: Making COUNTs and the Rest of Search Really Fast (Part II)

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

#postgresql

Abhisek Goswami: CUDA and PostgreSQL: Twins from two Worlds

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

#postgresql

Dimitri Fontaine: Zero-downtime Postgres upgrades with logical replication

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

#postgresql

Floor Drees: Conference Preview: EDB at PGConf.Asia 2026

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

#postgresql

Hollis Varden: Four PostgreSQL arguments that came out even

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

#postgresql

Hollis Varden: What deleting rows does to a PostgreSQL table

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

#postgresql

Christophe Pettus: All Your GUCs in a Row: port

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

#postgresql

Alexander Ioffe: Why is my Whale Query 1000x Slower in Prod? Databases hate skew, each hates it differently

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

#postgresql

Chris van Eijk: PostgreSQL row-level security for SaaS: what we measured

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

#postgresql

Chris van Eijk: Go, pgx and PostgreSQL row-level security, measured

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

#postgresql

Christophe Pettus: The Patch Is Coming From Inside the House

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

#postgresql

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

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

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