Recently, I’ve been hearing a lot of experienced PostgreSQL users reiterate this line: quot;pg dump is not a backup tool. quot; In fact, the documentation has recently been updated to avoid saying that it is a backup tool, to widespread relief. Experienced PostgreSQL users and developers have been...

   copy; Laurenz Albe Many a beginner falls into the trap of trigger recursion at some point. Usually, the solution is to avoid recursion at all. But for some use cases, you may have to handle trigger recursion. This article tells you what you need to know about the topic. If you were ever...

   After several months of development, version . of PostgreSQL Anonymizer has entered the beta phase, and this is an opportunity for us to launch a series of articles to present its new capabilities in preview For this first technical overview, let’s see how to generate fake data also known as ...

   Introduction This year, PGDay Lowlands was paired with PGDay UK , which gave me the chance to try something new taking the train directly from London to Amsterdam. Naturally, I was curious about passing through the famous tunnel under La Manche some folks call it the English Channel,...

   If you’ve done any Postgres development in C, you’re probably aware of the concept of memory contexts. The primary purpose of memory contexts is to absolve the developers of having to track every single piece of memory they allocated. But it’s about performance too, because memory contexts cache...

   pgsql tweaks is a bundle of functions and views for PostgreSQL The soucre code is available on GitLab, a mirror is hosted on GitHub. One could install the whole package, or just copy what is needed from the source code. The extension is also available on PGXN. General changes It is only a minor...

   Claire Giordano hosted Tom Lane on the Talking Postgres podcast on Wed Oct th. Robert Haas hosted the October Hacking Workshop. Teresa Giacomini, Isaac Alves, My Nguyen produced the Activity Book for Postgres v with advice from Ariana Padilla Acosta, Adam Wolk, Derk van Veen, Boriss Mejias, and...

   Amazing. Awesome. Well, but what is it We could store json data in Pg since PostgreSQL . ; so it’s been there for over years now. How is the new shiny thing different What does it allow you to do Let’s see if I can shed some light on it... For starters: SQL JSON is ; Continue...

   In this CNPG recipe, we explore three essential command line tools that simplify working with CloudNativePG in Kubernetes: view secret, view cert, and stern. These tools enhance tasks such as inspecting secrets, verifying certificates, and tailing logs across multiple pods, streamlining your...

   JSON TABLE, new in Postgres If you missed some of the headlines and release notes, Postgres added another huge JSON feature to its growing repository of strong JSON support with the JSON TABLE feature. JSON TABLE lets you query JSON and display and query data like it is native relational SQL....

   On August th, , we had the PostgreSQL October Meetup in Berlin. Amazon hosted it, and sponsored the Meetup in their office in the Brüderstraà e, in Berlin Mitte.

   Over the years, we occasionally get requests for more detail on release note items, particularly for the major release notes. Historically, our only response was to tell people to view the SGML XML file used to generate the web and PDF versions of the release notes. In the file, above each...

   Columnar databases are transforming the way we handle large datasets by storing data in columns rather than rows. This approach enhances performance, especially for analytical queries, by allowing faster data retrieval and efficient storage. As businesses generate more data than ever, understanding...

   The pg timeseries extension uses Hydra Columnar storage for historical data. Check this out if you want to know how this kind of storage compares to standard Postgres Heap storage during database writes.

   After a successful rd beta in August , the PostgreSQL development group released the GA version on September th. Recently, I blogged about some of the key logical replication features that you’ll see in PostgreSQL https: www.pgedge.com blog logical replication features in Postgres . ...

   sparql fdw Forreign Data Wrapper The sparql fdw is a foreign data wrapper to connect to query web databases with the SPARQL protocol from inside PostgreSQL written in Python. Test Against PostgreSQL As multicorn is already working with PostgreSQL , I tested the sparql fdw, too. It worked...

   There is something new you may not have seen in the release notes for Postgres . No, not a new feature I mean inside the actual release notes themselves The Postgres project uses the git program to track commits to the project, and now each item in the release notes has a link to the actual...

   A couple weeks ago, I drafted PGXN RFC Release Certification, which proposes to replace the simple inclusion of a SHA hash digests in PGXN release META.json files with a JWS signed release payload. From the introduction: This RFC therefore proposes to extend v distribution metadata with a...

   Given the success of the Extension Ecosystem Summit at PGConf.dev back in May, my colleague Floor Drees has organized a sequel, the Extension Ecosystem Summit EU on Tuesday, October , at the Divani Caravel Hotel in Athens. That’s Day at the same hotel as PGConf.eu. Tembo, Percona, Xata, and...

   I travel quite a lot for work. Most of it is in the US and Europe, but I get around to other places as well. Most of the time, connectivity, while not the greatest, isn ;t that bad, or hard. I run a VPN on my phone and laptop. I can set up my RDS connectivity ; The post RDS...

   PostgreSQL Person of the Week Interview with Yurii Rashkovskii: I was born and raised in Ukraine, and moved to Canada in without knowing much about it. I wanted to go as far west as I could to explore. That move changed my life a lot, and I now live on beautiful Vancouver Island in British...

   Dirk Krautschick and Christian Gohmann organized the . PostgreSQL User Group NRW MeetUp. Christoph Mönch Teggeder and Christoph Berg presented at the Meetup. Gülçin YÄ ldÄ rÄ m Jelinek organized the Prague PostgreSQL Meetup: September Edition. Adam Wolk and Mayuresh Bagayatkar Slides presented...

   Melanie Plageman ran a mentorship feedback session and was the guest on episode of Talking Postgres with Claire Giordano.

   In March of ’, I took over as the Lead Architect of my employer’s Ansible based automation for creating highly available PostgreSQL clusters.

   Tablespaces play an important role in database management systems, as they determine where and how database objects like tables and indexes are stored. Both Oracle and PostgreSQL have the concept of tablespaces, but they implement them differently based on the overall architecture of each database....

   With the introduction of failover slots in PostgreSQL , logical replication can now be effectively utilized in high availability environments. This feature ensures that logical replication continues seamlessly even if the publisher node fails and its physical standby is promoted as the new...

   My notes from the Open Source Summit Europe in Vienna, featuring fresh updates from open source communities, insights from the Xata booth, and highlights from our Postgres Happy Hour

   IntroductionAs usual, this project was prompted by multiple user reports with typical complaints, like ’SQL server executes the query times faster’ or ’Postgres doesn’t pick up my index’. The underlying issue that united these reports was frequently used VALUES sequences, typically transformed in...

   In one of the recent PostgresFM episodes, Michael Christofides and Nikolay discussed planning time and what can affect it. One of the obvious negative factors we’ve discussed is the large number of partitions a partition table might have.In this post, we’re using our Postgres.AI assistant to see...

   On th of September , Peter Eisentraut committed patch: Add temporal FOREIGN KEY contraints ; Add PERIOD clause to foreign key constraint definitions. This is supported for range and multirange types. Temporal foreign keys check for range containment instead of equality. ; This...