postgres Archives - 2ndQuadrant

Posts

How to deploy a multi-master BDR cluster in Kubernetes

March 9, 2020/0 Comments/in Cloud Native /by Gabriele Bartolini

Discover in this article and video how BDR can be easily and quickly deployed on Kubernetes thanks to our Cloud Native BDR Operator.

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

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

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

This article gives a step by step guide to utilizing Machine Learning capabilities with 2UDA. In the article, we’ll use an example 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. 2UDA version 11.6-1 combines: PostgreSQL 11.6 […]

Webinar: BDR – Latest Features & Updates [Follow Up]

January 17, 2020/1 Comment/in Bilal's PlanetPostgreSQL, Webinars /by Bilal Ibrar

BDR is a rapidly evolving project — and has been generating great interest from the Postgres community. In order to give further insights into BDR, how it works and where to best apply it, 2ndQuadrant organized a live webinar on 15th January 2020. The BDR – Latest Features and Updates webinar was hosted by Simon […]

Webinar: You forgot to put the WHERE in DELETE? [Follow Up]

December 12, 2019/0 Comments/in Nouman's PlanetPostgreSQL, Webinars /by Nouman

Human oversight is one of the many reasons for compromising a database. Disasters happen, but having a solid backup and disaster recovery plan in place can help your business mitigate such risks. Martín Marqués, Head of Support Operations at 2ndQuadrant, hosted a webinar on backup and disaster recovery options in PostgreSQL. The webinar: “You forgot […]

PostgreSQL 12: Implementing K-Nearest Neighbor Space Partitioned Generalized Search Tree Indexes

November 5, 2019/3 Comments/in 2ndQuadrant, Kirk’s PlanetPostgreSQL, PostgreSQL /by Kirk Roybal

K-nearest neighbor answers the question of “What is the closest match?”. PostgreSQL 12 can answer this question, and use indexes while doing it.

Developing on many versions of PostgreSQL at once

August 19, 2019/0 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

In a developer’s ideal world there’s only one stable and one development version of the product. Everyone updates immediately to the next stable version and nobody cares about anything older. As far as I can tell this has never actually happened, ever, in the history of anything. Working on many versions PostgreSQL is a mature […]

Using Docker Hub PostgreSQL images

May 17, 2019/1 Comment/in Craig's PlanetPostgreSQL /by craig.ringer

Docker Hub carries Docker images for PostgreSQL, based on Debian Stretch or Alpine Linux. These are not official PostgreSQL Development Group (PGDG) images from postgresql.org, they’re maintained in the Docker Library on Github. But as Docker adoption grows these are going to become more and more people’s first exposure to PostgreSQL. I tried these images […]

Geo-redundancy of PostgreSQL database backups with Barman

February 19, 2019/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

Barman 2.6 introduces support for geo-redundancy, meaning that Barman can now copy from another Barman instance, not just a PostgreSQL database.

Sequential UUID Generators

November 27, 2018/15 Comments/in 2ndQuadrant, Tomas' PlanetPostgreSQL /by Tomas Vondra

UUIDs are a popular identifier data type – they are unpredictable, and/or globally unique (or at least very unlikely to collide) and quite easy to generate. Traditional primary keys based on sequences won’t give you any of that, which makes them unsuitable for public identifiers, and UUIDs solve that pretty naturally. But there are disadvantages […]