Daniel Westermann

EDB BART 2.2, parallel full backups without using pg_basebackup

Some days ago EnterpriseDB released the latest version of its backup and recovery tool for PostgreSQL and EDB Postgres Advanced Server, release notes here. The main new features, at least for me, are backups using multiple(…)

An index only scan in PostgreSQL is not always index only

PostgreSQL supports index only scans since version 9.2 which was released in September 2013. The purpose of an index only scan is to fetch all the required values entirely from the index without visiting the table(…)

Some more zheap testing

Hervé already did some tests with zheap and documented his results yesterday. After some more discussions with Amit who did the session about zHeap at the conference here in Lisbon (you can(…)

Some psql features you are maybe not aware of

It is the time of The 10th Annual PostgreSQL Conference Europe, so this is the perfect time to blog about some tips and tricks around psql you'll love. psql is such a(…)

Inheriting super user privileges over a role automatically in PostgreSQL

In a recent project at a customer where we synchronize the users and group out of Active Directory we hit a little issue I was not aware of before. Suppose you have created a role in(…)

Getting started with Red Hat Satellite – Initial configuration

In the last post it was all about the Installation of Red Hat Satellite and the components that are used under the hood. In this post it is about doing the initial configuration so that packages(…)

Getting started with Red Hat Satellite – Installation

This is the start of a series of posts I wanted to write for a long time: Getting started with Red Hat Satellite. Just in case you don't know what it is, this statement from the official Red Hat website(…)

EDB containers for OpenShift 2.3 – PEM integration

This blog refers to an older version of EDB's Postgres on Kubernetes offering that is no longer available. A few days ago EnterpriseDB announced the availability of version 2.3 of the EDB containers for OpenShift. The main new feature in(…)

We are proud to announce:

(no words required for this post, the image says it all)(…)

When we do a pg_dump and right afterwards truncate a table which is in the dump, what happens?

Being at customers is always the best way to learn. Today while discussing that pg_dump will always produce a consistent dump because it uses the "repeatable read" isolation level this question came up: What happens when we(…)