BE SHARING

Daniel Westermann

ODA workshop at Arrow ECS

17.06.2015 by Daniel Westermann

On the 16th and 17th of June David Hueber, Georges Grey and myself had the chance to attend the ODA hands on workshop at Arrow ECS. Lead Trainer Ruggero Citton (Oracle ODA Product Development) did the first day(…)

Database Administration & Monitoring

What is more efficient: arrays or single columns values? – oracle

15.06.2015 by Daniel Westermann

In the last post on this topic it turned out that using an array as a column type needs more space than using a column per value in PostgreSQL. Now I’ll do the same test case in Oracle.

Database Administration & Monitoring

What is more efficient: arrays or single column values?

15.06.2015 by Daniel Westermann

In PostgreSQL ( as well as in other rdbms ) you can define columns as arrays. What I wondered is: What is more efficient when it comes to space: Creating several columns or just creating once column as array? The(…)

Database Administration & Monitoring

SQL Interpolation with psql

15.06.2015 by Daniel Westermann

The PostgreSQL psql utility provides some really nice features. One of these features is SQL interpolation which allows us to do interesting things, e.g. reading files and analyze the results directly in the database. This post(…)

Database Administration & Monitoring

A free PostgreSQL cloud database?

14.06.2015 by Daniel Westermann

Recently I was looking for a free PostgreSQL cloud database service for testing. Why? Because I’d like to use such a cloud instance for testing no matter on which workstation or OS I am currently on. Another reason is, that(…)

Database Administration & Monitoring

PostgreSQL portable?

12.06.2015 by Daniel Westermann

What a surprise: Headed over to the sourceforge page, downloaded, installed (which is just a matter of next/next/next) : Not really the latest patchset but far more than I(…)

Database management

using dbms_server_alert in combination with a custom monitoring solution

12.06.2015 by Daniel Westermann

Lot’s of companies do not use Grid- or Cloud Control for monitoring their Oracle databases for various reasons but rather use open source tools like nagios. And lot of those either implemented custom script frameworks or rely(…)

Database management

draft release notes for PostgreSQL 9.5 online

12.06.2015 by Daniel Westermann

Bruce Momjian, one of the PostgreSQL Core members, just compiled the first draft version of the release notes for the upcoming PostgreSQL 9.5 Some of the goodies that will show up: BRIN indexes(…)

Database management

quickly exchange code or text between workstations or teams

12.06.2015 by Daniel Westermann

In a recent project I faced the following situation: One the one hand I had to execute scripts on a customer’s workstation while on the other hand I had to integrate the results of these scripts into a report on(…)

Database management

Testing postgresql development snapshots

12.06.2015 by Daniel Westermann

If you want to test some of the features that will be coming with the next postgresql release even before an official beta version is released you can use the daily(…)