Database Administration & Monitoring EDB Postgres Advanced Server 9.6 BETA released 08.11.2016 by Daniel Westermann 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.
Database Administration & Monitoring How to destroy your performance: PL/SQL vs SQL 14.10.2016 by Daniel Westermann 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(…)
Database Administration & Monitoring OTN Appreciation Day : ADVM 11.10.2016 by Daniel Westermann 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 -(…)
Database Administration & Monitoring How to patch Postgres Plus Advanced Server in a Standby configuration 09.10.2016 by Daniel Westermann 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(…)
Database Administration & Monitoring Fun with PL/SQL code reviews – Part 1 06.10.2016 by Daniel Westermann 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(…)
Database Administration & Monitoring How to patch Postgres Plus Advanced Server 05.10.2016 by Daniel Westermann 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(…)
Database Administration & Monitoring Running PostgreSQL on ZFS on Linux – Compression 01.10.2016 by Daniel Westermann 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(…)
Database Administration & Monitoring Running PostgreSQL on ZFS on Linux – Fun with snapshots and clones 30.09.2016 by Daniel Westermann In the last post we looked at how to get a ZFS file system up and running on a CentOS 7 host and how to enable the auto mount of the ZFS file systems. In this post(…)
Database Administration & Monitoring Running PostgreSQL on ZFS on Linux 28.09.2016 by Daniel Westermann ZFS for Solaris is around for several years now (since 2015). But there is also a project called OpenZFS which makes ZFS available on other operating systems. For Linux the announcement(…)
Database Administration & Monitoring Connecting your PostgreSQL instance to an Oracle database – Debian version 27.09.2016 by Daniel Westermann Some time ago I blogged about attaching your PostgreSQL instance to an Oracle database by using the oracle_fdw foreign data wrapper. This resulted in a comment which is the reason for this post: Doing the same(…)