PostgreSQL

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.

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(…)

The (almost) same sample schema for all major relational databases (1) – PostgreSQL

The are times when it would be nice to have the same sample schema in all relational databases you or your company are working on. This is great if you want to compare how different databases execute the same tasks(…)