PostgreSQL Archives - 2ndQuadrant

How EDB Became the Leader in the Postgres Market

September 30, 2020/0 Comments/in PostgreSQL /by Ed Boyajian

I’m delighted to share that EDB has acquired 2ndQuadrant, a global Postgres solutions and tools company. Our combined team of experts will drive Postgres innovation and growth everywhere, making EDB the largest dedicated provider of Postgres products and solutions worldwide, with more customers than any other Postgres company. Why now? Postgres is exploding in popularity […]

PostgreSQL VACUUM and ANALYZE Best Practice Tips

September 30, 2020/0 Comments/in 2ndQuadrant, PostgreSQL, PostgreSQL 13, Sadeq's PlanetPostgreSQL /by Sadequl Hussain

VACUUM and ANALYZE are the two most important PostgreSQL database maintenance operations. A vacuum is used for recovering space occupied by “dead tuples” in a table. A dead tuple is created when a record is either deleted or updated (a delete followed by an insert). PostgreSQL doesn’t physically remove the old row from the table […]

PostgreSQL 13: LIMIT … WITH TIES

September 16, 2020/3 Comments/in 2ndQuadrant, Alvaro's PlanetPostgreSQL, PostgreSQL 13 /by Álvaro Herrera

A simple description of the new WITH TIES standard feature in PostgreSQL 13.

7 Best Practice Tips for PostgreSQL Bulk Data Loading

September 15, 2020/2 Comments/in PostgreSQL, PostgreSQL 13, Sadeq's PlanetPostgreSQL /by Sadequl Hussain

Sometimes, PostgreSQL databases need to import large quantities of data in a single or a minimal number of steps. This process can be sometimes unacceptably slow. In this article, we will cover some best practice tips for bulk importing data into PostgreSQL databases.

How to Get the Best Out of PostgreSQL Logs

September 3, 2020/3 Comments/in 2ndQuadrant, PostgreSQL, PostgreSQL 13, Sadeq's PlanetPostgreSQL /by Sadequl Hussain

Learn how to effectively configure PostgreSQL log management for troubleshooting performance problems.

Oracle to PostgreSQL — Cursors and ltrees

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

This time we talk about using ltree as an alternative to PostgreSQL cursors.

Parallelism comes to VACUUM

September 2, 2020/0 Comments/in 2ndQuadrant, Masahiko's Planet PostgreSQL, PostgreSQL, PostgreSQL 13 /by Masahiko Sawada

Vacuum is one of the most important features for reclaiming deleted tuples in tables and indexes. Without vacuum, tables and indexes would continue to grow in size without bounds. This blog post describes the PARALLEL option for VACUUM command, which is newly introduced to PostgreSQL13. Vacuum Processing Phases Before discussing the new option in depth […]

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.