2ndQuadrant Archives - 2ndQuadrant

PostgreSQL 12: Partitioning is now faster

September 17, 2019/0 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/0 Comments/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 […]

Generated columns in PostgreSQL 12

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

Computed columns in PostgreSQL 12 are here, but still have a ways to go.

Webinar: Migration to PostgreSQL [Follow up]

June 27, 2019/0 Comments/in 2ndQuadrant, Webinars /by Nouman

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

Postgres-XL and global MVCC

April 2, 2019/0 Comments/in 2ndQuadrant, Koichi’s PlanetPostgreSQL, Postgres-XL /by Koichi Suzuki

Back to the PG I’m very excited to become a 2ndQuadrant member. I was involved in PostgreSQL activities in NTT group (Japanese leading ICT company, see here and here), including log shipping replication and PostgreSQL scale out solution as PostgresXC and PostgresXL. At NTT I had several chances to work very closely with 2ndQuadrant. After three years involvement in deep […]

Sequential UUID Generators on SSD

January 9, 2019/4 Comments/in 2ndQuadrant, Tomas' PlanetPostgreSQL /by Tomas Vondra

After I shared the sequential UUID benchmarks a couple of weeks ago, one of the points raised in feedback was the choice of the storage space. I’ve intentionally used a fairly weak storage system (RAID10 on three 7.2k SATA drives) because I wanted to demonstrate the benefits. But a couple of readers suggested using SSDs might significantly reduce […]

Webinar: pglogical and Postgres-BDR Update [Follow Up]

January 8, 2019/0 Comments/in 2ndQuadrant, Liaqat's PlanetPostgreSQL /by Liaqat Andrabi

Since the release of v3, Postgres-BDR has evolved into the go-to clustering technology built specially for businesses that require geographically distributed databases with multiple masters. To get an update on Postgres-BDR’s development, new features, and future roadmap, 2ndQuadrant held the pglogical and Postgres-BDR Update webinar as part of its PostgreSQL webinar series. The webinar was […]

PostgreSQL 9.3 EOL – Why is it Important to Upgrade?

January 3, 2019/0 Comments/in 2ndQuadrant, Liaqat's PlanetPostgreSQL, PostgreSQL /by Liaqat Andrabi

After the final release of patch 9.3.25 on November 8th 2018, PostgreSQL 9.3 is no longer supported. Therefore it’s time for all users of PG 9.3 to upgrade their databases to a newer supported version. The benefits of having a supported version are many and that’s what Craig Ringer talks about in the Q&A session […]

Databases vs. encryption

December 5, 2018/10 Comments/in 2ndQuadrant, Tomas' PlanetPostgreSQL /by Tomas Vondra

Let’s assume you have some sensitive data, that you need to protect by encryption. It might be credit card numbers (the usual example), social security numbers, or pretty much anything you consider sensitive. It does not matter if the encryption is mandated by a standard like PCI DSS or if you just decided to encrypt […]

Webinar : Introduction to OmniDB [Follow Up]

November 30, 2018/0 Comments/in 2ndQuadrant, Liaqat's PlanetPostgreSQL, OmniDB /by Liaqat Andrabi

A database management tool that simplifies what is complex and drives performance. OmniDB is one such tool with which you can connect to several different databases – including PostgreSQL, Oracle, MySQL and others. 2ndQuadrant recently hosted a webinar on this very topic: Introduction to OmniDB. The webinar was presented by OmniDB co-founders and PostgreSQL consultants […]