2ndQuadrant Archives - 2ndQuadrant

Webinar: Using SSL with PostgreSQL and pgbouncer [Follow Up]

November 14, 2019/0 Comments/in 2ndQuadrant, Webinars /by Liaqat Andrabi

Securing data in motion is a necessity in today’s world. PostgreSQL provides a way to encrypt and authenticate communication by using a Secure Sockets Layer or SSL protocol. 2ndQuadrant hosted a webinar to give an introduction on using SSL, encryption and authentication methods, and how to successfully configure and deploy SSL with PostgreSQL. The webinar […]

PostgreSQL 12: Implementing K-Nearest Neighbor Space Partitioned Generalized Search Tree Indexes

November 5, 2019/3 Comments/in 2ndQuadrant, Kirk’s PlanetPostgreSQL, PostgreSQL /by Kirk Roybal

K-nearest neighbor answers the question of “What is the closest match?”. PostgreSQL 12 can answer this question, and use indexes while doing it.

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

Postgres-BDR: It is also about fast safe upgrades

October 15, 2019/2 Comments/in 2ndQuadrant, Tom's PlanetPostgreSQL /by Tom Kincaid

In 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

October 15, 2019/0 Comments/in 2ndQuadrant, Alvaro's PlanetPostgreSQL, PostgreSQL /by alvherre

I 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

October 14, 2019/4 Comments/in 2ndQuadrant, Alvaro's PlanetPostgreSQL, PostgreSQL /by alvherre

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

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: A Few Special-Case Performance Enhancements

September 24, 2019/2 Comments/in 2ndQuadrant, John’s PlanetPostgreSQL /by John Naylor

With 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

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

Partitioning enhancements in PostgreSQL 12

July 15, 2019/1 Comment/in 2ndQuadrant, Kirk’s PlanetPostgreSQL /by Kirk Roybal

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