Declarative 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 […]
PostgreSQL 12: Partitioning is now faster
/0 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 […]
Webinar: Business Intelligence with Window Functions in PostgreSQL [Follow up]
/0 Comments/in PostgreSQL, Webinars /by Bilal IbrarWindow functions are a very useful tool; and since their introduction 10 years ago, they have been gradually adopted for various use cases where a simple aggregation is not flexible enough: for example incremental totals, moving averages, etc. The latest features introduced in PostgreSQL complete the implementation according to the SQL:2011 standard, adding capabilities such […]
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
/11 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
/0 Comments/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 […]
Webinar: Postgres Vacuuming Through Pictures [Follow up]
/0 Comments/in Liaqat's PlanetPostgreSQL, Webinars /by Liaqat AndrabiVacuuming is a key feature of PostgreSQL databases to keep databases healthy and optimized. For this, Autovacuum is configured to conserve space by removing obsolete disk usage, and to optimize database performance by speeding up sequential scans, just as one example. To discuss this topic in-depth, 2ndQuadrant hosted the “Postgres Vacuuming Through Pictures” webinar. The […]
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
/0 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 […]
Postgresql Interval, Date, Timestamp and Time Data Types
/0 Comments/in Elein’s PlanetPostgreSQL /by EleinDoes anyone really know what time it is? First we have the bare bones of the PostgreSQL Interval, Date and Timestamp Data types. Here are the questions: What types are they? And what options do they have? What postgresql.conf variables affect date and time i/o? Available Date and Time Data types Date day of year […]