Daniel Westermann

A look at PostgreSQL 9.6 – Killing idle transactions automatically

A common issue with databases: The guy at floor 2 did some work on the database and then rashly left for lunch because the lady on floor 1 is already waiting for him. Unfortunately he did not close his transaction(…)

A look at PostgreSQL 9.6 – progress reporting for VACUUM operations

Vacuum in PostgreSQL is one of the most important points to consider when managing a PostgreSQL instance. Usually vacuum is running in the background and just gets the job done. But, as always, there are situations when(…)

A look at PostgreSQL 9.6 – The wait interface

For a long time there was no real wait interface in PostgreSQL core. Now, with the upcoming 9.6, pg_stat_activity was extended to provide more meaningful information for what a session is currently waiting on.

Happy birthday PostgreSQL

Connecting your PostgreSQL instance to a Microsoft SQL Server instance

In the last posts I looked at how you can connect Oracle and MariaDB/MySQL to a PostgreSQL instance. In this post I'll do the same with a MS SQL Server instance.

Interested in the most advanced open source database? Where you can meet us in June …

Are you interested in what PostgreSQL can do for you? You can join us at the following events in June:(…)

Connecting your PostgreSQL instance to a MariaDB/MySQL instance

Some time ago I blogged on how to connect your PostgreSQL instance to an Oracle instance (here and here). In this post I'll do the same with a MariaDB/MySQL instance.

The (almost) same sample schema for all major relational databases (3) – MySQL/MariaDB

Some time ago I blogged on how to get the "Dell DVD Store Database Test Suite" installed in PostgreSQL and Oracle. This time we'll do the same on a MariaDB instance.

Maintenance scenarios with EDB Failover Manager (3) – Witness node

In the last posts ( Maintenance scenarios with EDB Failover Manager (1) – Standby node , Maintenance scenarios with EDB Failover Manager (2) – Primary node ) we looked at how to perform maintenance(…)

Maintenance scenarios with EDB Failover Manager (2) – Primary node

In the last post I looked at how you can do maintenance operations on the standby node when you are working in a PostgreSQL cluster protected by EDB Failover Manager. In this post I'll look on how(…)