Starting with arrays in PostgreSQL is as simple as declaring a column as integer[], inserting some values, and you are done. Or building the array on the fly. SELECT ’ 1,2,3 ’::int[]; SELECT array[1,2,3]; int4 --------- 1,2,3 (1 row) array --------- 1,2,3 (1 row) The official documentation provides...

   Happy New Year I’m excited to announce release 0.9 of pg statviz, the minimalist extension and utility pair for time series analysis and visualization of PostgreSQL internal statistics. This is a significant feature release that expands the scope of analysis to include several new modules and a...

   Why static batch size configuration breaks down in real world networks and how automatic batch size tuning improves snapshot throughput.

   Meet the mentee: Anushka Saxena worked with the project maintainers on transforming the documentation for CloudNativePG, as part of the LFX mentorship program.

   PostgreSQL 19 changes this week cumulative statistics support for reading writing auxiliary data from to disk added pg createsubscriber support for handling existing publications added pg sync replication slots() retry logic added PostgreSQL 18 articles PostgreSQL 18 Asynchronous Disk I O - Deep...

   When people first hear instant recovery, they often assume it is a replacement for backup or worse, a risky shortcut only experts should attempt. But the truth is exactly the opposite. Instant recovery does not challenge any design boundary of PostgreSQL. It simply rejects a premise the kernel...

   When the database won’t start and there’s no backup available, most teams assume the game is over. But that’s not true the data is still on disk, it just lost the ability to speak. PostgreSQL data files remain transparent and readable, but here’s the problem - without the data dictionary, you...

   PostgreSQL 19 changes this week ALTER TABLE ALTER TABLE ... SPLIT PARTITION ... syntax added ALTER TABLE ... MERGE PARTITIONS ... syntax added pg stat progress analyze column started by added pg stat progress vacuum columns mode and started by added vacuumdb option --dry-run added PostgreSQL 18...

   Back in September 2025, David Fetter asked on IRC, about a tool to quickly load CSV to database. One that would require minimal configuration, will try to figure out as much as possible on its own. I thought that it would be great idea. Plus, I’m trying to learn more JavaScript Node, so figured...

   On December 10th, 2025, the PostgreSQL December Meetup in Frankfurt (Main) took place. We had two speakers, and a nice dinner. This Meetup was organized around the IT-Tage, and the Meetup organizers had booked a reeting toom in the Scandic Frankfurt Museumsufer. About 15 minutes walking from the...

   As you maybe know, some time ago I made paste service, mostly to use for queries, or related text to share on IRC. One part of it is that it also has pretty printer of provided queries. Recently I realized that in case of complex join conditions, the output is, well, sub-optimal. For example...

   One of things people learn is that adding indexes isn’t free. All write operations (insert, update, delete) will be slower – well, they have to update index. But realistically – how much slower? Full tests should involve lots of operations, on realistic data, but I just wanted to see...

   I am writing this post over the weekend but scheduling it to be published on Tuesday, after the PG DATA CfP closes, because I do not want to distract anyone, including myself, from the submission process. A couple of months ago, I created a placeholder in my GitHub, promising to publish pg acm...

   I do a fair amount of benchmarks as part of development, both on my own patches and while reviewing patches by others. That often requires dealing with noise, particularly for small optimizations. Here’s an overview of ways I use to filter out random variations noise. Most of the time it’s easy -...

   PostgreSQL 18 made one very important change – data block checksums are now enabled by default for new clusters at cluster initialization time. I already wrote about it in my previous article. I also mentioned that there are still many existing PostgreSQL installations without data checksums...

   Introduction PostgreSQL has built-in support for logical replication. Unlike streaming replication, which works at the block level, logical replication replicates data changes based on replica-identities, usually primary keys, rather than exact block addresses or byte-by-byte copies. PostgreSQL...

   PostgreSQL 18 has arrived with some fantastic improvements, and among them, the RETURNING clause enhancements stand out as a feature that every PostgreSQL developer and DBA should be excited about. In this blog, I’ll explore these enhancements, with particular focus on the MERGE RETURNING clause...

   Most teams assume data loss means restore from backup. This article introduces the Instant Recovery mindset, explains why PostgreSQL makes it possible, and how PDU turns recoverability into a practical, predictable process.

   In this post, I describe experiments on the write-versus-read costs of PostgreSQL’s temporary buffers. For the sake of accuracy, the PostgreSQL functions set is extended with tools to measure buffer flush operations. The measurements show that writes are approximately 30% slower than reads. Based...

   Recently during a post-migration activity, we had to populate a very large table with a new UUID column (NOT NULL with a default) and backfill it for all existing rows. Instead of doing a straight: ALTER TABLE ... ADD COLUMN ... DEFAULT ... NOT NULL; we chose the commonly recommended performance...

   A client accidentally ran rm -rf , wiping out the entire OS and database. After disk recovery experts salvaged the data files, PDU adapted to this domestic PostgreSQL variant and completed full data recovery in just 4 hours.

   When pg type and pg attribute are partially destroyed, how do you piece together a corrupted database? This real-world case reveals an ingenious workaround that saved 46% of the data.

   DROP TABLE with no backup? Most consider it game over. Discover how PDU achieves the impossible - scanning raw disk blocks and matching table structures to resurrect your lost data.

   A corrupted disk. A dead database. Unusable backups. 1.5TB of critical business data hanging by a thread. This is the story of how PDU turned an impossible situation into a triumph.

   Meet the mentee: Yash Agarwal worked with the project maintainers on adding chaos testing to CloudNativePG, as part of the LFX mentorship program.

   PostgreSQL 19 changes this week pg stat replication slots newly added column slotsync skip at renamed to slotsync last skip pg dsm registry allocations improvments to display of the size of DSAs and dshashes PostgreSQL 18 articles A deeper look at old UUIDv4 vs new UUIDv7 in PostgreSQL 18 (2025-12...

   On 14th of December 2025, Alexander Korotkov committed patch: Implement ALTER TABLE ... MERGE PARTITIONS ... command   This new DDL command merges several partitions into a single partition of the target table. The target partition is created using the new createPartitionTable() function with...

   We talked to Matthew Mols, Sr. Director of Engineering at pgEdge, about how CloudNativePG enables them to meet the requirements of their customers using just open source.

   2025 marked a historic turning point for CloudNativePG, headlined by its acceptance into the CNCF sandbox and a subsequent application for incubation. Throughout the year, the project transitioned from a high-performance operator to a strategic architectural partner within the cloud-native...

   Modern databases must know how to handle failures gracefully, whether they are system failures, power failures, or software bugs, while also ensuring that committed data is not lost. PostgreSQL achieves this with its recovery mechanism; it allows the recreation of a valid functioning system state...