Postgresql String Functions and Operators. This blog today is going to talk about strings: how they are stored, how they are input, and lots of examples of how to use string operators and functions in order to manipulate them. Strings, strings, strings. What we are not going to cover is regular expressions, although we […]
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
/8 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 […]
Generated columns in PostgreSQL 12
/1 Comment/in 2ndQuadrant, Kirk’s PlanetPostgreSQL /by Kirk RoybalComputed columns in PostgreSQL 12 are here, but still have a ways to go.
Webinar: Migration to PostgreSQL [Follow up]
/0 Comments/in 2ndQuadrant, Webinars /by NoumanAmong the many reasons to Migrate to PostgreSQL, available support is a key driver for many businesses deciding to migrate. PostgreSQL is an open source software which is also extendable. You can implement missing features in it as per your business need. Migration to PostgreSQL, however, can be a tricky decision as it requires planning, […]
Beautiful things, strings.
/0 Comments/in Elein’s PlanetPostgreSQL /by EleinPostgresql String Functions and Operators. This blog today is going to talk about strings: how they are stored, how they are input, and lots of examples of how to use string operators and functions in order to manipulate them. Strings, strings, strings. What we are not going to cover is regular expressions, although we […]