Postgres Covering Indexes and the Visibility Map

Covering indexes in Postgres came up in our weekly tech call because of a query optimization review one of the teams ...

Working with Ansible, PostgreSQL and Docker

While working on creating some of our internal training labs for PostgreSQL, I have had the pleasure of working with ...

Postgres Security Patches Related to the Search Path

There were some security patches released this month for Postgres, to put further restrictions on pathways that ...

Why column stores?

Introduction

PostgreSQL Backups

There are at least four ways to back up a Postgres database: SQL dump, filesystem snapshots, continuous archiving, and ...

Postgres partial indexes on email address domains

When I first heard of Postgres partial indexes, I knew immediately that this would have solved a problem I had in MySQL ...

Fix: SQL Server to PostgreSQL Linked Server Error - "Requested conversion is not supported."

Migrate Postgres Database from EC2 instance to RDS using AWS DMS (Data Migration Services)

In this post, we will explore one approach to Migrate PostgreSQL DB on EC2 instance to RDS instance using AWS Data ...

Concurrent Processing Issues with Distributed Transactions Glitch

Introduction

This is my first post in Pythian blog, and I wanted to share interesting use-cases that we've ...

Migrating Oracle Workloads to Google Cloud - PostgreSQL on Cloud SQL or GCE

When working with clients on database migration, there are a range of options we help ...

Comparing Pgpool-II and PgBouncer

While I was in the process of determining different HA solutions for PostgreSQL, Pgpool and PgBouncer both came into ...