PostgreSQL Archives - 2ndQuadrant

Posts

Webinar: BDR – Latest Features & Updates [Follow Up]

January 17, 2020/0 Comments/in Bilal's PlanetPostgreSQL, Webinars /by Bilal Ibrar

BDR is a rapidly evolving project — and has been generating great interest from the Postgres community. In order to give further insights into BDR, how it works and where to best apply it, 2ndQuadrant organized a live webinar on 15th January 2020. The BDR – Latest Features and Updates webinar was hosted by Simon […]

Support for PostgreSQL’s System identifier in Barman

January 9, 2020/0 Comments/in Florins PlanetPostgreSQL /by Florin Irion

The latest Barman 2.10 release introduces support for the system identifier of a PostgreSQL instance. In this article, I will answer a few questions explaining what a system identifier is and why it is a good thing that Barman uses it. What is the PostgreSQL system identifier? PostgreSQL gives a unique system identifier to every […]

Webinar: You forgot to put the WHERE in DELETE? [Follow Up]

December 12, 2019/0 Comments/in Nouman's PlanetPostgreSQL, Webinars /by Nouman

Human oversight is one of the many reasons for compromising a database. Disasters happen, but having a solid backup and disaster recovery plan in place can help your business mitigate such risks. Martín Marqués, Head of Support Operations at 2ndQuadrant, hosted a webinar on backup and disaster recovery options in PostgreSQL. The webinar: “You forgot […]

Setting SSL/TLS protocol versions with PostgreSQL 12

November 27, 2019/2 Comments/in 2ndQuadrant, Eisentraut's PlanetPostgreSQL, PostgreSQL /by Peter Eisentraut

PostgreSQL 12 contains two new server settings: ssl_min_protocol_version ssl_max_protocol_version As the names indicate, these are used to control the oldest (minimum) and newest (maximum) version of the SSL and TLS protocol family that the server will accept. (For historical reasons, in PostgreSQL, all settings related to SSL and TLS are named ssl_something, even though TLS […]

Webinar: PostgreSQL Partitioning [Follow up]

October 28, 2019/1 Comment/in 2ndQuadrant, PostgreSQL, Webinars /by Bilal Ibrar

With the recent release of PostgreSQL 12, there’s been a lot of interest in the latest version and by popular demand, the team at 2ndQuadrant organized a live webinar on “PostgreSQL Partitioning”. The webinar was hosted by Simon Riggs, CTO 2ndQuadrant, who gave an overview of PostgreSQL partitioning features and how they play a key […]

Webinar: New Features in Postgres 12 [Follow up]

September 26, 2019/0 Comments/in 2ndQuadrant, PostgreSQL, Webinars /by Bilal Ibrar

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 […]

PostgreSQL 12: Partitioning is now faster

September 17, 2019/4 Comments/in 2ndQuadrant, David's PlanetPostgreSQL /by David Rowley

Table 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 […]

Webinar: Business Intelligence with Window Functions in PostgreSQL [Follow up]

August 29, 2019/0 Comments/in PostgreSQL, Webinars /by Bilal Ibrar

Window 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

August 19, 2019/0 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

In 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 […]

PostgreSQL: Regular expressions and pattern matching

July 31, 2019/1 Comment/in Haroon's PlanetPostgreSQL /by Muhammad Haroon

A 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 […]