Daniel Westermann

Can I do it with PostgreSQL? – 3 – Tablespaces

In the last posts of this series we talked about restore points and how you could do things that would require the dual table in Oracle. In this post we'll look at tablespaces. This(…)

Can I do it with PostgreSQL? – 2 – Dual

In the first post of this series we talked about restore points. Another question that pops up from time to time is how you can do things in PostgreSQL that would require the dual(…)

Can I do it with PostgreSQL? – 1 – Restore points

When discussing with customers about PostgreSQL we often hear that they can do things in one database that they can not do in PostgreSQL. Most of the times this is not true and you actually can do it in PostgreSQL.

EDB Postgres Advanced Server 9.6 BETA released

Yesterday EnterpriseDB released the beta of the next version of Postgres Advanced Server. You can sign up for the beta program here and download the software here.

How to destroy your performance: PL/SQL vs SQL

Disclaimer: This is in no way a recommendation to avoid PL/SQL. This post just describes a case I faced at a customer with a specific implementation in PL/SQL the customer (and me) believed is the most efficient way of doing(…)

OTN Appreciation Day : ADVM

Tim Hall had the idea that as many people as possible would write a small blog post about their favorite Oracle feature and we all post them on the same day. Here is my favorite feature: ADVM -(…)

How to patch Postgres Plus Advanced Server in a Standby configuration

In the last post we looked at how you can patch a Postgres Plus Advanced server. Wouldn't it be nice, in a standby configuration, to patch the standby first without touching the master, then do a controlled(…)

Fun with PL/SQL code reviews – Part 1

For quite a long time I did not work anymore with PL/SQL and was quite happy when I had the chance to review some code at a customer. The status today: I am not that happy anymore(…)

How to patch Postgres Plus Advanced Server

As with any other software there comes the time when you need to patch your Postgres Plus Advanced Server instances. Is that different from patching Community PostgreSQL? Yes and no :) The difference is(…)

Running PostgreSQL on ZFS on Linux – Compression

In the last posts in this little series we looked at how to get a ZFS file system up and running on a CentOS 7 host and how snapshots and clones can be used(…)