PostgreSQL Archives - Page 2 of 15 - 2ndQuadrant

Advanced partition matching for partition-wise join

August 28, 2020/0 Comments/in 2ndQuadrant, Ashustosh's Planet PostgreSQL, PostgreSQL, PostgreSQL 13 /by Ashutosh Bapat

Earlier I had written a blog about partition-wise join in PostgreSQL. In that blog, I had talked about an advanced partition matching technique which will allow partition-wise join to be used in more cases. In this blog we will discuss this technique in detail. To recap, the basic partition matching technique allows a join between two […]

Oracle to PostgreSQL — Cursors and Common Table Expressions

August 18, 2020/0 Comments/in 2ndQuadrant, Kirk’s PlanetPostgreSQL, PostgreSQL /by Kirk Roybal

PostgreSQL has quite a number of better algorithmic alternatives to cursors. We’ll start by examining the advantages of Common Table Expressions.

PostgreSQL 13: Don’t let slots kill your primary

July 30, 2020/0 Comments/in 2ndQuadrant, Alvaro's PlanetPostgreSQL, PostgreSQL 13 /by Álvaro Herrera

One of the interesting new features in PostgreSQL for some time now is the ability to control removal of WAL files using replication slots. The dark side is that replication slots can cause disks to fill up with old WAL, killing the main production server. In this article I explain PostgreSQL replication slots, and how a new feature in PostgreSQL 13 helps prevent this problem.

Unicode normalization in PostgreSQL 13

July 23, 2020/3 Comments/in Eisentraut's PlanetPostgreSQL, PostgreSQL /by Peter Eisentraut

Unicode equivalence Unicode is a complicated beast. One of its numerous peculiar features is that different sequences of codepoints can be equal. This is not the case in legacy encodings. In LATIN1, for instance, the only thing that is equal to ‘a’ is ‘a’ and the only thing that is equal to ‘ä’ is ‘ä’. […]

How to Monitor PostgreSQL 12 Performance with OmniDB – Part 2

July 21, 2020/0 Comments/in 2ndQuadrant, PostgreSQL, Sadeq's PlanetPostgreSQL, Technology /by 2ndQuadrant Press

In a previous article of this series, we created a two-node PostgreSQL 12 cluster in the AWS cloud. We also installed and configured 2ndQuadrant OmniDB in a third node. The image below shows the architecture: We could connect to both the primary and the standby node from OmniDB’s web-based user interface. We then restored a […]

Barman 2.11: barman-cloud-restore and barman-cloud-wal-restore

July 21, 2020/5 Comments/in 2ndQuadrant, Anna's PlanetPostgreSQL, Barman, DevOps, PostgreSQL /by Anna Bellandi

Thanks to the new utilities barman-cloud-restore and barman-cloud-wal-restore introduced in Barman 2.11, it is now possible to execute the recovery of a PostgreSQL instance using a full backup previously executed using barman-cloud-wal-archive and barman-cloud-backup commands. Let’s discover together how to implement this in the following article.

Barman Cloud – Part 2: Cloud Backup

July 16, 2020/0 Comments/in 2ndQuadrant, Anna's PlanetPostgreSQL, Barman, DevOps, PostgreSQL /by Anna Bellandi

In the first part of this blog, Jonathan explained how the barman-wal-archive command works. Now, assuming you followed those instructions, you have a properly configured PostgreSQL instance up and running. In this second part, I will show you how the barman-cloud-backup command works.

How to Monitor PostgreSQL 12 Performance with OmniDB – Part 1

June 25, 2020/0 Comments/in 2ndQuadrant, OmniDB, PostgreSQL, Sadeq's PlanetPostgreSQL /by 2ndQuadrant Press

OmniDB is an open-source, graphical database management tool developed by 2ndQuadrant, a world-leader in PostgreSQL technologies and services. OmniDB is a browser-based, universal client tool that can manage major database engines like PostgreSQL, MariaDB, MySQL, and Oracle. Other soon-to-be-supported engines include SQLite, Firebird, MS SQL Server, and IBM DB2. Like any excellent database client software, OmniDB […]

Oracle to PostgreSQL: Reasons to Migrate

June 23, 2020/9 Comments/in 2ndQuadrant, Kirk’s PlanetPostgreSQL, PostgreSQL /by Kirk Roybal

PostgreSQL has quite a few compelling advantages, some of which are not found in any other database management system. This article will outline the ones that are most interesting to the Oracle developer seeking to do a migration or investigate alternatives for new development. To prevent this article from becoming another list of PostgreSQL features, it […]

Oracle to PostgreSQL: Basic Architecture

June 17, 2020/4 Comments/in 2ndQuadrant, Kirk’s PlanetPostgreSQL, PostgreSQL /by Kirk Roybal

This article provides the Oracle database administrator with equivalent PostgreSQL architecture knowledge. The process is a bit loose, but it is sufficient to bootstrap the concepts that are transferable and identify the ones that are not.

2ndQuadrant is now part of EDB

Advanced partition matching for partition-wise join

Oracle to PostgreSQL — Cursors and Common Table Expressions

PostgreSQL 13: Don’t let slots kill your primary

Unicode normalization in PostgreSQL 13

How to Monitor PostgreSQL 12 Performance with OmniDB – Part 2

How to Monitor PostgreSQL 12 Performance with OmniDB – Part 1

Oracle to PostgreSQL: Reasons to Migrate

Oracle to PostgreSQL: Basic Architecture

Support & Services

Products

Postgres Learning Center

About Us