The new PostgreSQL 12 release is just around the corner and by popular demand, the team at 2ndQuadrant hosted “New Features in Postgres 12″ webinar. The 1 hour + long session, conducted by Peter Eisentraut (Core Team Member of the PostgreSQL Project), gave an in-depth preview of everything new in PostgreSQL 12, improvements to partitioning, generated […]
Postgres-BDR: It is also about fast safe upgrades
/0 Comments/in 2ndQuadrant, Tom's PlanetPostgreSQL /by Tom KincaidIn the past year, I have had many conversations with many clients and prospects about Postgres-BDR. For those of you who don’t know this Postgres-BDR has been in production for many mission critical deployments for quite some time. We have more clients coming on board each month. Most recently, I have been meeting with […]
Managing another PostgreSQL Commitfest
/0 Comments/in 2ndQuadrant, Alvaro's PlanetPostgreSQL, PostgreSQL /by alvherreI have written about managing a PostgreSQL commitfest before. During the PostgreSQL 13 development cycle, I did it again. This time I used a different strategy, mostly because I felt that there was excessive accumulation of very old patches that had received insufficient attention. So apart from bugfixes (which are always special cases), I focused […]
PostgreSQL 12: Foreign Keys and Partitioned Tables
/0 Comments/in 2ndQuadrant, Alvaro's PlanetPostgreSQL, PostgreSQL /by alvherreNow that PostgreSQL 12 is out, we consider foreign keys to be fully compatible with partitioned tables. You can have a partitioned table on either side of a foreign key constraint, and everything will work correctly. Why do I point this out? Two reasons: first, when partitioned tables were first introduced in PostgreSQL 10, they […]
A convenient way to launch psql against postgres while running pg_regress
/0 Comments/in Craig's PlanetPostgreSQL /by craig.ringerI got tired of looking up regression_output/log/postmaster.log to find the PGSOCKET to use to connect to a running pg_regress‘s temp-install postgres so I wrote a little shell function for it. My patch to print a connst in pg_regress never got merged so I needed a workaround. I’m sure I’m not the only one, so here’s […]
Replication configuration changes in PostgreSQL 12
/0 Comments/in Ian's PlanetPostgreSQL, repmgr /by Ian BarwickHistorically, PostgreSQL’s replication configuration has been managed via a configuration parameters stored in a dedicated configuration file, recovery.conf, which has been present in PostgreSQL since the introduction of archive recovery in PostgreSQL 8.0. One of the major changes in PostgreSQL 12, co-authored by 2ndQuadrant is the replacement of recovery.conf and the conversion of recovery.conf parameters […]
Webinar: New Features in Postgres 12 [Follow up]
/0 Comments/in 2ndQuadrant, PostgreSQL, Webinars /by Bilal IbrarThe new PostgreSQL 12 release is just around the corner and by popular demand, the team at 2ndQuadrant hosted “New Features in Postgres 12″ webinar. The 1 hour + long session, conducted by Peter Eisentraut (Core Team Member of the PostgreSQL Project), gave an in-depth preview of everything new in PostgreSQL 12, improvements to partitioning, generated […]
Release 11 of the PostgreSQL Buildfarm client
/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew DunstanRelease 11 of the PostgreSQL Buildfarm client is now available. The release includes numerous bug fixes plus following features: Allow a list of branches as positional arguments to run_branches.pl This overrides what is found in the config file. The list can’t include metabranches like ALL, nor can it contain regexes. improve diagnostic capture for git […]
PostgreSQL 12: A Few Special-Case Performance Enhancements
/0 Comments/in 2ndQuadrant, John’s PlanetPostgreSQL /by John NaylorWith every new release of PostgreSQL, there are a range of performance enhancements. Some are system-wide and affect every user, but most are highly specific to a certain use case. In this post, I am going to briefly highlight three improvements in PG12 that speed up certain operations. 1. Minimal decompression of TOAST values TOAST […]
PostgreSQL 12: Partitioning is now faster
/4 Comments/in 2ndQuadrant, David's PlanetPostgreSQL /by David RowleyTable partitioning has been evolving since the feature was added to PostgreSQL in version 10. Version 11 saw some vast improvements, as I mentioned in a previous blog post. During the PostgreSQL 12 development cycle, there was a big focus on scaling partitioning to make it not only perform better, but perform better with a […]
PG Phriday: Postgres 12 Revs up Vacuum
/0 Comments/in Shaun's PlanetPostgreSQL /by Shaun ThomasAny long-time user of Postgres is likely familiar with VACUUM, the process that ensures old data tuples are identified and reused to prevent unchecked database bloat. This critical element of maintenance has slowly, but surely, undergone incremental enhancements with each subsequent release. Postgres 12 is no different in this regard. In fact, there are two […]