Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Apply (1) filters
7 blog posts in 13 categories

How to Optimize PostgreSQL Logical Replication

Logical Replication or pglogical is a method of replicating specific data objects (tables) and their changes to the replica in real-time which is similar to streaming replication. The term logical is in contrast to physical replication, which uses exact block addresses and byte-by-byte replication. This blog provides tips on how to optimize logical replication system.

Comparing Data Stores for PostgreSQL - MVCC vs InnoDB

MVCC is one of the primary ways for most of the RDBMS to solve read-write contention. In this blog, we’ll see in details how PostgreSQL and InnoDB implement the same. Also, we’ll see some of the major differences between their implementation.

Benchmarking Managed PostgreSQL Cloud Solutions - Part One: Amazon Aurora

A multi-part series of articles on PostgreSQL benchmarking in the cloud. Part one is an overview of available benchmarking tools for PostgreSQL followed by testing Amazon Aurora PostgreSQL based on the Amazon Guide for Benchmarking PostgreSQL.

One Security System for Application, Connection Pooling and PostgreSQL - The Case for LDAP

This blog describes how you can use LDAP for both authentication and connection pooling with your PostgreSQL database.

PostgreSQL on the Rise: 2018 Postgres Findings & 2019 Trends

PostgreSQL has seen real growth in the past few years, getting closer and closer to MySQL, which continues to be the world’s most popular open source database. In this blog we explore what’s been happening with PostgreSQL in 2018 and some predictions for the future.

What's New in PostgreSQL 11

This blog provides an overview of the new features and functions that can be found in PostgreSQL 11 including stored functions, partitioning, and much more!

Become a PostgreSQL DBA: Provisioning and Deployment

This post is the first in the “Become a PostgreSQL DBA” blog series and will cover provisioning and deployment.