PostgreSQL

PostgreSQL 17: pg_buffercache_evict()

In PostgreSQL up to version 16, there is no way to evict the buffer cache except by restarting the instance. In Oracle you can do that since ages with “alter system flush buffer cache“, but not(…)

PostgreSQL 17: Split and Merge partitions

Since declarative partitioning was introduced in PostgreSQL 10 there have been several additions and enhancements throughout the PostgreSQL releases. PostgreSQL 17, expected to be released around September/October this year, is no exception to that and will come with two(…)

PostgreSQL 17: Add allow_alter_system GUC

Some time ago I’ve written about the options to disable the “alter system” command in PostgreSQL. While there is nothing up to PostgreSQL 16 to do this natively, there are solutions for this requirement (see linked(…)

PostgreSQL 17: Convert a physical replica to a logical replica using pg_createsubscriber

Logical replication in PostgreSQL came with Version 10, which is already out of support. I’ve written about this a long time ago but the basic building blocks are still the same. Setting(…)

Getting started with Greenplum – 6 – Why Greenplum?

Now that we have the basic knowledge for operating a Greenplum cluster we should talk about why Greenplum can be option and what are the benefits of such a system. Again, here are the previous posts:(…)

Create REST API from your database in minute with Feathers.js

Creating REST APIs is a fairly repetitive task. You’re always rewriting the Create, Read, Update, Delete methods…In my search for a framework capable of generating a REST API, I discovered Feathers, a simple and useful framework for Node.js.

Getting started with Greenplum – 5 – Recovering from failed segment nodes

This is the next post in this little Greenplum series. This time we’ll look at how we can recover from a failed segment. If you are looking for the previous post, they are here: Getting started(…)

Getting started with Greenplum – 4 – Backup & Restore – databases

This is the fourth part of the Greenplum blog series, the previous ones are here: Getting started with Greenplum – 1 – Installation, Getting started with Greenplum – 2 – Initializing and(…)

Getting started with Greenplum – 3 – Behind the scenes

If you followed part 1 and part 2 of this little blog series you now have a running Greenplum system. There is one coordinator host and there are two segment hosts. In(…)

Getting started with Greenplum – 2 – Initializing and bringing up the cluster

In the last post we’ve configured the operating system for Greenplum and completed the installation. In this post we’ll create the so called “Data Storage Areas” (which is just a mount point or directory) and initialize(…)