A Journey Through PostgreSQL Events Introduction Community recognition (transparency, inclusivity, organisational balance) If I organise a PostgreSQL event does it have to be recognised? Are community-recognised events better than those that aren’t? Conferences a quick flyover (pgDays, pgConfs,...

   Quick announcement to say that I’ve replaced the ancient markdown parser with a new one, discount, which supports tables, code fences, definition lists, and more. I reindexed pg clickhouse this morning and it’s sooo nice to see the table properly formatted.New uploads will use this parser for...

   PostgreSQL 17 introduced streaming I O - grouping multiple page reads into a single system call and using smarter posix fadvise() hints. That alone gave up to 30% faster sequential scans in some workloads, but it was still strictly synchronous: each backend process would issue a read and then sit...

   Earlier this year we started a program ( Developer U ) to help colleagues who show promise for PostgreSQL Development to become contributors. Meet: Nishant Sharma, Staff SDE, who maintains a list of places in the world he has yet to visit.

   Data privacy regulations such as GDPR, CCPA, and HIPAA have made it increasingly important for organisations to protect personally identifiable information (PII) in their databases. Whether you’re creating a development environment from production data, sharing datasets with third parties, or...

   On December 11, the PGDay CERN 2026 CfP committee met to finalize the talk selection. The committee members are listed here: Tobias Bussmann, SCNAT (chair, non voting) Abel Cabezas Alonso, CERN Maurizio De Giorgi, CERN Andreas Geppert, ZKB Julia Gugel, migrolino Tom Hagel, Volue Svitlana Lytvynenko...

   From time to time I see questions from otherwise well informed people about how the PostgreSQL Build farm checks how pg upgrade checking is done across versions, e.g. how does it check upgrading from release 9.5 to release 18. I realize that this isn’t well documented anywhere, so here is a...

   PostgreSQL maintenance doesn’t have to mean downtime anymore. With pgEdge’s zero-downtime node addition, you can perform critical maintenance tasks like version upgrades, hardware replacements, and cluster expansions without interrupting production workloads. Your applications stay online. Your...

   There is common misconception that troubles most developers using PostgreSQL: tune VACUUM or run VACUUM, and your database will stay healthy. Dead tuples will get cleaned up. Transaction IDs recycled. Space reclaimed. Your database will live happily ever after. But there are couple of dirty secrets...

   While moving production database workloads towards cloud-native (Kubernetes) environments has become very popular lately, plenty of users still rely on good old Docker containers. Compared to running PostgreSQL on bare metal, on virtual machines, or via a Kubernetes operator, Docker adds a bit of...

   In a recent Postgres patch authored by Greg Sabino Mullane, Postgres has a new step forward for data integrity: data checksums are now enabled by default.This appears in the release notes as a fairly minor change but it significantly boosts the defense against one of the sneakiest problems in data...

   Postgres Ibiza (PGIBZ): An open source conference designed to bring together people with a love for PostgreSQL in Ibiza, a relaxed place for fresh and innovative discussions. An international event run by the nonprofit PostgreSQL Espa a. This was the first time that the Data Bene team attended the...

   The ClickHouse blog has a posted a piece by yours truly introducing pg clickhouse, a PostgreSQL extension to run ClickHouse queries from PostgreSQL: While clickhouse fdw and its predecessor, postgres fdw, provided the foundation for our FDW, we set out to modernize the code & build process, to...

   In this blog, we explore Postgres constraints through the pg constraint catalog, covering table vs. column constraints, constraint triggers, domains and more.

   In Part 1 we loaded our documentation into PostgreSQL. In Part 2 we chunked those documents and generated vector embeddings. Now it’s time to put it all together with an API that your applications can use.In this final post, we’ll deploy the pgEdge RAG Server to provide a simple HTTP API for asking...

   There’s nothing simple about simplification It is very common to want to slim down the size of geometries, and there are lots of different approaches to the problem.We will explore different methods starting with ST Letters for this rendering of the letter a .SELECT ST Letters(’a’); This is a good...

   PostgreSQL is highly suitable for powering critical applications in all industries. However, to run critical applications, there are key requirements which are absolutely needed: High-Availability and automatic failover. This document explains which options are available and which problems one can...

   In Part 1 of this series, we loaded our documentation into PostgreSQL using the pgEdge Document Loader. Our documents are sitting in the database as clean Markdown content, ready for the next step: turning them into something an LLM can search through semantically.In this post, we’ll use pgEdge...

   On Nov. 20, the day after GIS Day, Elizabeth Christensen and I hosted the 7th annual PostGIS Day, a celebration of the Little Spatial Database That Could. Brought to you this year by Snowflake, the event featured an amazing collection of speakers from around the globe from India to Africa, Europe...

   Last week, I read The Register’s coverage of MongoDB CEO Chirantan CJ Desai telling analysts that a super-high growth AI company ... switched from PostgreSQL to MongoDB because PostgreSQL could not just scale. (The Register)I believe you can show the value of your own technology without tearing...

   PGUG.EE met on December 3 2025 in Estonia, organized by Kaarel Moppel & Ervin Weber Talks Mayuresh Bagayatkar Alexander Matrunich Ants Aasma Kaarel Moppel Bruce Momjian spoke at the PG Armenia Community Meetup, organised by Emma Saroyan on December 4 2025.

   I have attended over one hundred Postgres meetups over the years. The usual format is: food with individual discussion, lecture with group questions, and finally more individual discussion. I just spoke at an Armenia PostgreSQL User Group meetup and the event organizer Emma Saroyan did something...

   In the past there have been many discussions about using UUID as a primary key in PostgreSQL. For some applications, even a BIGINT column does not have sufficient range: it is a signed 8 byte integer with range’9,223,372,036,854,775,808 to 9,223,372,036,854,775,807. Although these values look big...

   The PostgreSQL Hacking Workshop will be taking a well-earned Christmas break in December of 2025. The future of the workshop is a little bit unclear, because I’m continuing to have a bit of trouble finding enough good talks online to justify doing one per month: the best source of talks for the...

   Earlier this year we started a program ( Developer U ) to help colleagues who show promise for PostgreSQL Development to become contributors. Meet Bryan Green, working on the Platform Operations team at EDB, who just enjoys understanding how things work at the lowest levels.

   Previously... In our first JIT episode, we discussed how we could, using copy-patch, easily create a JIT compiler for PostgreSQL, with a slight improvement in performance compared to the PostgreSQL interpreter. In our second episode, I talked about the performance wall and how hard it was to have a...

   The secret to unlocking performance gains often lies not just in what you ask in a query, but in how Postgres finds the answer. The Postgres EXPLAIN system is great for understanding how data is being queried. One of secretes to reading EXPLAIN plans is understanding the type of scan done to...

   As a PostgreSQL-specific monitoring solution, pgwatch is mostly known for storing collected metrics in a PostgreSQL database. While great, as you probably should just Use Postgres for everything xD... in some scenarios and specific setups, this might be a limitation. You may want to store your...

   Retrieval-Augmented Generation (RAG) has become one of the most practical ways to give Large Language Models (LLMs) access to your own data. Rather than fine-tuning a model or hoping it somehow knows about your documentation, RAG lets you retrieve relevant content from your own sources and provide...

   In a PostgreSQL database, sequences provide a convenient way to generate a unique identifier, and are often used for key generation. From the community, PostgreSQL provides functions and SQL language to help manage sequence generation, but the sequences themselves are not without limitations in a...