postgres Archives - 2ndQuadrant

Posts

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

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.

Which partition contains a specific row in my PostgreSQL database?

September 9, 2020/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

If you are enjoying working with PostgreSQL declarative partitioning, you might be wondering how to check which partition contains a specific record. While it is quite obvious in the cases of list or range partitioning, it is a bit trickier with hash partitioning. Don’t worry. Here you can find a quick way to determine which […]

How to Monitor PostgreSQL 12 Performance with OmniDB – Part 2

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

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

Why we chose immutable application containers for our Cloud Native PostgreSQL and BDR products

July 6, 2020/0 Comments/in Cloud Native /by Gabriele Bartolini

Cloud Native PostgreSQL and Cloud Native BDR are the two Kubernetes operators written by 2ndQuadrant entirely from scratch in the Go language and relying exclusively on the Kubernetes API.

Local Persistent Volumes and PostgreSQL usage in Kubernetes

June 22, 2020/0 Comments/in 2ndQuadrant, Cloud Native /by Gabriele Bartolini

Can I use PostgreSQL in Kubernetes and expect to achieve performance results of the storage that are comparable to traditional installations on bare metal or VMs? In this article I go through the benchmarks we did in our own Private Cloud based on Kubernetes 1.17 to test the performance of local persistent volumes using OpenEBS […]

How to use Logistic Regression Machine Learning model with 2UDA – PostgreSQL and Orange (Part 5)

May 21, 2020/0 Comments/in 2ndQuadrant, Seemab's PlanetPostgreSQL /by Semab Tariq

This article gives a step by step guide to utilizing Machine Learning capabilities with 2UDA. In this article, we will use examples of Animals to predict whether they are Mammals, Birds, Fish or Insects. Software versions We are going to use 2UDA version 11.6-1 to implement the Machine Learning model. This version 11.6-1 combines: PostgreSQL […]

Keep your libraries updated and nobody gets hurt

May 14, 2020/0 Comments/in Jimmy's Planet PostgreSQL /by Jimmy Angelakos

Don’t make people practice software archaeology – keep your system updated. Updates? One of the benefits of the open-source world is the unmatched ability to issue updates rapidly to correct bugs and security vulnerabilities. Software bug fixes keep streaming in: from recently introduced regressions, to long-standing bugs undetected for years, they are corrected by a […]

Backup manifests and pg_verifybackup in PostgreSQL 13

May 4, 2020/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

PostgreSQL 13 introduces two useful features to enhance automated validation of physical backups: backup manifests and a new tool called pg_verifybackup. In this short article I attempt to provide an overview of them.

How to use the SVM Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 2)

February 27, 2020/0 Comments/in 2ndQuadrant, Seemab's PlanetPostgreSQL /by Semab Tariq

This article gives a step by step guide to utilizing Machine Learning capabilities with 2UDA. In this article, we’ll use examples of Animals to predict whether they are Mammals, Birds, Fish or Insects. Software versions We’re going to use 2UDA version 11.6-1 to implement the Machine Learning model. This version 11.6-1 combines: PostgreSQL 11.6 Orange […]

Read 2ndQuadrant’s response to the COVID – 19 emergency here