On th of January , Nathan Bossart committed patch: Allow changing autovacuum max workers without restarting. ; This commit introduces a new parameter named autovacuum worker slots that controls how many autovacuum worker slots to reserve during server startup. Modifying this new parameter...

   Autovacuum is one of PostgreSQL’s most powerful features, designed to maintain database health and optimize performance by automating routine maintenance tasks. However, improper configuration can lead to performance bottlenecks, excessive costs due to resource inefficiency, or uncontrolled table...

   People continue to tell me on a semi regular basis how much they appreciate these approximately annual posts, the first of which came out in April of . I think this might be more because the project doesn’t have enough official ways to recognize people than it is an endorsement of the...

   And as promised, the recording is here Enjoy As promised ; January meetup recording

   PGDay CERN was held on January , at CERN, Genève, Switzerland List of contributions: Tobias Bussmann Swiss PostgreSQL Users Group Maurizio De Giorgi CERN Miroslav Potocky CERN Rafal Kulaga CERN Antonin Kveton CERN Martin Zemko CERN Adrien Obernesser dbi services Gulcin...

   Recently there was a nice article on the Planet PostgreSQL feed on Postgres’ parallel query capabilities and the pertinent tuning parameters. All good and logical, the main settings and considerations were highlighted...but then I suddenly remembered that there’s one more parallelism relevant...

   If you are using PostgreSQL for analytics or large scale aggregations, you might occasionally notice the planner making false assumptions regarding the number of rows. While this isn’t a problem for small aggregates, it is indeed an issue for large scale aggregations featuring many different...

   I have been working recently on making various scanners and parsers in PostgreSQL thread safe, and this article is a bit of a brain dump to record what I did, what the different steps were, because all of that was pretty difficult to piece together, and it might be worth recording somewhere what...

   One of my favorite uses of JSONB functionality is to unpivot data. Continue reading Unpivoting data using JSONB

   The schedule of the free event is available Open Day in Bolzano Italy : schedule available The schedule of the next free event organized by PgTraining is available. The event, that will be held in the great NOI Techpark in Bolzano Italy will be organized in two parts: a talk session...

   Not all operations require the same level of locking, and PostgreSQL offers tools and techniques to minimize locking impact.

   The PostgreSQL Project is present with a booth at FOSDEM ever since . And ever since we organize a Devroom, starting we also have our own PGDay on the Friday before FOSDEM. This year it’s the th FOSDEM PGDay, skipping and for obvious reasons. This blog post provides useful...

   That happened one long and warm Thai evening when I read another paper about the re optimisation technique in which the authors used Postgres as a base for implementation. Since I had nearly finished with the WIP patch aiming to do the same stuff in the Postgres fork, I immediately began comparing...

   PostgreSQL changes pg stat io count IOs as bytes instead of blocks for some operations postgres fdw : SCRAM authentication can be passed through using new option use scram passthrough psql x can be appended to various list commands e.g. dtx to force expanded mod df, do, dAo, and ...

   The PostGIS Team is pleased to release PostGIS . . . This version requires PostgreSQL , GEOS . or higher, and Proj . . To take advantage of all features, GEOS . is needed. SFCGAL . is needed to enable postgis sfcgal support. To take advantage of all SFCGAL features, SFCGAL . ...

   Please considering joining us next month February for a discussion of Heikki Linnakangas’s talk on The Wire Protocol, from PGCONF.EU . For those not familiar with the concept, this hacking workshop is basically a virtual meetup: you watch the talk, and then you sign up to participate in...

   How we discovered a trivial bug in pgagroal The importance of testing with not so usual setups This week we found a trivial and silly bug in pgagroal https: github.com agroal pgagroal :target blank . This post is a brief description about such bug, not because it is important on itself,...

   On st of December , David Rowley committed patch: Enable BUFFERS with EXPLAIN ANALYZE by default ; The topic of turning EXPLAIN’s BUFFERS option on with the ANALYZE option has come up a few times over the past few years. In many ways, doing this seems like a good idea as it may be more...

   Cloud costs can quickly spiral out of control if resources are not optimized. One of the most significant contributors to these costs is CPU core allocation, which forms the basis of the instance size with every major cloud provider. Many organizations over provision cores for their PostgreSQL...

   As I have been on several CfP committees CfPC for PostgreSQL conferences, I like to share my experiences. Submissions When you submit more than one talk, think about the additional work of the CfPC. Every member has to read almost all submissions and to vote for each one of it. The exceptions...

   PostgreSQL is one of the most powerful database systems in the world. I have always been passionate about its great power, especially its modern SQL language features. However, that doesn’t mean everything is great. There are areas where it hurts. Novice users unaware of the problem might get into...

   copy; Laurenz Albe During a training session on tuning autovacuum, a participant asked me, Why is autovacuum vacuum scale factor set to . Rather than replying with a guess or a wisecrack Because that’s the way somebody implemented it or If you don’t like it, submit a patch , I...

   Catching up with the last weeks of , and entering into , these are the last contributions we were able to know about: Emma Saroyan created the Armenia PUG and organized their first Meetup. Elizabeth Christensen and Valeria Kaplan helped organizing it. Bruce Momjian was the speaker,...

   This blog explains locking mechanisms in PostgreSQL, focusing on table level locks that are required by Data Definition Language DDL operations.

   is picking up speed, and with CommitFest underway we’re seeing some more PostgreSQL changes again. In news closer to home, the PgPedia Week format has been expanded to include links to recent articles on PostgreSQL , other PostgreSQL related newsletters published in the preceding...

   On th of November , Peter Eisentraut committed patch: Support LIKE with nondeterministic collations ; This allows for example using LIKE with case insensitive collations. There was previously no internal implementation of this, so it was met with a not supported error. This adds the...

   Your database is configured for the needs of your day to day OLTP online transaction processing application workload, but what if you need to run analytics queries against your application data How can you do that without compromising the performance of your application OLTP OLAP activity...

   If you’re managing a PostgreSQL database and handling sensitive data or PII, the answer is simple: You need data at rest encryption. This isn’t just a ;nice to have ; feature it’s often a legal or regulatory requirement. Compliance auditors, security officers, and privacy conscious...

   Yup, you read it right. Idle transactions can cause massive table bloat that the vacuum process may not be able to address. Bloat causes degradation in performance and can keep encroaching disk space with dead tuples. This blog delves into how idle transactions cause table bloat, why this is...

   HexaCluster is back with its Summary of PostgreSQL in like our article in . We would first like to thank all PostgreSQL Users, Contributors, Organizations, and Sponsors who have directly or indirectly contributed to an exponential growth, year over year, in PostgreSQL adoptions across the...