An interview with 2ndQuadrant: whats new and whats coming in Postgres

Posted By: PostgresOpen on Thursday, August 31

Continuing on down our list of some of the great sponsors we get to sit down and talk to, today we jump in with Simon Riggs of 2ndQuadrant.

PostgresOpen SV: 2ndQuadrant works both with a bunch of US clients as well as contributing to much of Postgres and the ecosystem around it. How does the mix of contributing to core Postgres as well as direct client interaction help improve Postgres overall?

Simon Riggs: 2ndQuadrant is a major developer of open source PostgreSQL, contributing both major new features and bug fixes regularly. We use our direct client interactions to focus these contributions so we can prioritise the biggest issues for our clients. With over 15 years of customer engagements we have been able to identify bottlenecks and then contribute towards enterprise features that fix them in PostgreSQL, benefiting everyone that uses it.

PostgresOpen SV: Postgres 10 is just around the corner, 2ndQuadrant have many developers that contributed to it. Can you share a bit on what you're most excited about in Postgres 10?

Simon Riggs: It’s the Big One - the release where we finally get logical replication into core!

2ndQuadrant has supported BDR and pglogical for some years now, though we now have some very important aspects of that added to core PostgreSQL. The new logical replication uses two new commands: PUBLICATION and SUBSCRIPTION to allow users to define flows of changed data from one server to another.

This work has taken many years of effort to bring to the current level, resulting from many 2ndQuadrant developers and various reviewers and testers. It opens up many possible use-cases with this important new replication technology.

PostgresOpen SV: Because you are an active participant in the community you have a good idea for where the project is headed beyond Postgres 10... What’s the future look like?

Simon Riggs: Very good! Spoiler alert - we win!

Open source PostgreSQL has been growing year on year and we’re attracting interest from the largest enterprises now. There are still some large predators out there but the community is big enough and strong enough to push forwards.

Technically we continue to tune, innovate and evolve. Expect to see many further performance features, new ways of developing and ease of use features - whatever customers need to succeed with PostgreSQL.

From 2ndQuadrant you can expect some big new developments around Bi Directional Replication (BDR), though we also have things brewing around Postgres-XL 10, Barman, repmgr 4, pglogical 3 and pgbouncer as well as other existing projects.

Recent developments include the release of OmniDB, a new web-based admin tool for both PostgreSQL and other DBMS, specially designed around rapid response and ease of use.

We have pursued a joint strategy of providing both working code (available now) and later submitting the features into core PostgreSQL. Postgres-BDR is an open source project from 2ndQuadrant that provides multi-master replication for PostgreSQL. One of the greatest achievements to come out of our work on BDR is the logical replication technology that will be available in PostgreSQL 10, as I previously mentioned. We will be submitting further enhancements of performance and robustness into later releases of PostgreSQL. You can read more about the Postgres-BDR roadmap here.

PostgresOpen SV: What are you doing about cloud?

Simon Riggs: We’ve been encouraging cloud usage for many years now with contributions such as energy saving low-power mode, EXTENSIONs, database block checksums, group commit and a slew of backup and replication features all specifically aimed at cloud usage.

We’re happy that various cloud vendors have been using PostgreSQL in the cloud for many years now and we believe it’s important for users to have both choice and quality.

2ndQuadrant has offered consulting services and support to customers using cloud services for many years. 2ndQuadrant offers the Trusted PostgreSQL Architecture (TPA) tool to orchestrate and deploy database services for on-premise, public or hybrid clouds. 2ndQuadrant uses TPA to offer Managed and Supported DBaaS to customers, particularly around Postgres-BDR and Postgres-XL, as well as standard Postgres.

PostgresOpen SV: Do you see a lot of people moving to PostgreSQL from other databases? If yes, how do you help them with the migration process?

Simon Riggs: PostgreSQL is the most popular database when it comes to new adoption. Even existing users of other databases are flocking towards PostgreSQL - and it’s not just to save money. PostgreSQL is fully capable of securely supporting enterprise database systems.

We have developed specialized tools to facilitate migrations from Oracle and other database management systems. Our team not only consists of the largest collective of PostgreSQL experts globally, they also have a deep knowledge of other DBMS such as Oracle and MySQL.

2ndQuadrant believes in promoting open source PostgreSQL as a solution that is trusted globally by large and small businesses in various industry verticals, highlighting that it's developed by a vibrant community focused on making it more powerful with every release. Using PostgreSQL allows users to break free from vendor lock-in and design a database that is customized for their business needs, something that any company would benefit from.