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 […]
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
/2 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
/5 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
/2 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 […]
Developing on many versions of PostgreSQL at once
/0 Comments/in Craig's PlanetPostgreSQL /by craig.ringerIn a developer’s ideal world there’s only one stable and one development version of the product. Everyone updates immediately to the next stable version and nobody cares about anything older. As far as I can tell this has never actually happened, ever, in the history of anything. Working on many versions PostgreSQL is a mature […]
Postgres is the coolest database – Reason #5: It can not be bought out
/13 Comments/in Umair's PlanetPostgreSQL /by Umair ShahidWhen I wrote about Reason #3: No Vendor Lock-in, I leaned on the liberal PostgreSQL License and the fact that there are many vendors that can Support PostgreSQL in production. Another aspect that deserves its own mention is the fact that PostgreSQL can not be bought. Let me explain the significance of that statement. MySQL. […]
PostgreSQL: Regular expressions and pattern matching
/1 Comment/in Haroon's PlanetPostgreSQL /by Muhammad HaroonA regular expression is a special text string used to describe a search pattern. PostgreSQL’s regular expressions supports three separate approaches to pattern matching: POSIX-style regular expressions (BREs and EREs) SIMILAR TO operator added in SQL:1999 SQL LIKE operator There are some more advanced techniques for advanced pattern matching requirements but those will very likely […]
PostgreSQL Award
/0 Comments/in Mark's PlanetPostgreSQL /by Mark WongPostgreSQL was presented with the 2019 O’Reilly Open Source Award for Lifetime Achievement in Portland, Oregon, Thursday July 18th during OSCON. I had the honor of accepting that award alongside Bruce Momjian and Christophe Pettus. Starting last year in 2018, these awards were presented to projects and the first Lifetime Achievement award was given to […]
Partitioning enhancements in PostgreSQL 12
/3 Comments/in 2ndQuadrant, Kirk’s PlanetPostgreSQL /by Kirk RoybalDeclarative partitioning got some attention in the PostgreSQL 12 release, with some very handy features. There has been some pretty dramatic improvement in partition selection (especially when selecting from a few partitions out of a large set), referential integrity improvements, and introspection. In this article, we’re going to tackle the referential integrity improvement first. This […]