2ndQuadrant Archives - Page 3 of 15 - 2ndQuadrant

Business Continuity at 2ndQuadrant – How We Remain Effective in Emergencies

March 10, 2020/0 Comments/in 2ndQuadrant, Business, Featured /by Umair Shahid

Ensuring high availability for our clients’ PostgreSQL databases is our primary business objective. We are able to achieve that by ensuring availability of our PostgreSQL experts round the clock and around the world. Just like we plan failover and switchover contingencies for our clients, we plan for backups and backups-of-backups for business continuity so our […]

Researching PostGIS slowness (2019 edition)

February 27, 2020/2 Comments/in 2ndQuadrant, Alvaro's PlanetPostgreSQL, PostgreSQL /by Álvaro Herrera

Just as last year was ending, one of our long-time customers came to us because one of their long-existing PostgreSQL queries involving PostGIS geometry calculations was much slower for specific values. We researched the problem and found out how to solve it; read on! What we found as the cause of the problem will surprise […]

Webinar: All you need to know about CREATE STATISTICS [Follow Up]

February 27, 2020/0 Comments/in 2ndQuadrant, Webinars /by Nouman

Tomas Vondra, PostgreSQL Database Engineer at 2ndQuadrant, presented a webinar on CREATE STATISTICS command in PostgreSQL. The command was initially introduced in PostgreSQL 10 and saw further improvements in PostgreSQL 12. This command allows the database to collect multi-column statistics which helps the optimizer understand dependencies between columns, produces more accurate estimates and results in […]

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

Announcing New PostgreSQL Online Training Series

February 13, 2020/0 Comments/in 2ndQuadrant, training /by Umair Shahid

2ndQuadrant’s training courses are very popular amongst PostgreSQL professionals and enthusiasts, and have hosted more than 500 trainees in the last 10 years. Our current Public and On-Site training options, however, have their limitations. We are often asked: “When are you going to offer a training course in my region?“ It’s disheartening to tell people […]

Releasing Cloud Native BDR Operator for Kubernetes

February 5, 2020/0 Comments/in 2ndQuadrant, Cloud Native /by Gabriele Bartolini

I am very excited to announce the first release of “Cloud Native BDR Operator“ for Kubernetes. BDR Operator is the first 2ndQuadrant product to be launched in the Cloud Native landscape and it is part of our long term commitment in this area: 2ndQuadrant indeed is a Silver member of the Cloud Native Computing Foundation […]

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

Barman Cloud – Part 1: WAL Archive

January 27, 2020/0 Comments/in 2ndQuadrant, Barman, DevOps, Featured, Jonathan's PlanetPostgreSQL, PostgreSQL /by Jonathan Battiato

Preamble How many current Barman users have thought about saving backups in a remote destination in the cloud? How many have thought about taking that backup directly from the PostgreSQL server itself? Well, since Barman 2.10 this is now possible! How? Let’s discover that together in the following articles.

Setting SSL/TLS protocol versions with PostgreSQL 12

November 17, 2019/2 Comments/in 2ndQuadrant /by Peter Eisentraut

PostgreSQL 12 contains two new server settings:: ssl_min_protocol_version ssl_max_protocol_version As the names indicate, these are used to control the oldest (minimum) and newest (maximum) version of the SSL and TLS protocol family that the server will accept. (For historical reasons, in PostgreSQL, all settings related to SSL and TLS are named ssl_something, even though TLS […]

Webinar: Using SSL with PostgreSQL and pgbouncer [Follow Up]

November 14, 2019/0 Comments/in 2ndQuadrant, Webinars /by Liaqat Andrabi

Securing data in motion is a necessity in today’s world. PostgreSQL provides a way to encrypt and authenticate communication by using a Secure Sockets Layer or SSL protocol. 2ndQuadrant hosted a webinar to give an introduction on using SSL, encryption and authentication methods, and how to successfully configure and deploy SSL with PostgreSQL. The webinar […]

Business Continuity at 2ndQuadrant – How We Remain Effective in Emergencies

Researching PostGIS slowness (2019 edition)

Webinar: All you need to know about CREATE STATISTICS [Follow Up]

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

Announcing New PostgreSQL Online Training Series

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

Setting SSL/TLS protocol versions with PostgreSQL 12

Webinar: Using SSL with PostgreSQL and pgbouncer [Follow Up]

Support & Services

Products

Postgres Learning Center

About Us