Daniel Westermann

quickly exchange code or text between workstations or teams

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

Testing postgresql development snapshots

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

What that in-memory term is about, and what not

Everybody is talking about in-memory databases these days. And everybody is talking about columnar store for sets of data because this can be a benefit for analytic queries. And a lot of people start mixing these terms not realizing that(…)

Optimized Row Columnar (ORC) format in PostgreSQL

Nowadays everybody is talking about columnar storage format. What can PostgreSQL do in this area? There is no native support for that in PostgreSQL but thanks to the fact that PostgreSQL is highly extensible there is a(…)

tmux – an alternative to screen

You may already use screen for multiplexing a terminal. This is especially useful when you want to start long running processes on a server and do not want to loose the connection because of a ssh connection timeout,(…)

does impdb into a compressed table really compress data?

Today at a customer we discussed the following scenario: To refresh a test database a datapump export and import was implemented. To save space on the test system the idea came up to compress the data on the test system.

What will be coming with the next major version of postgresql ?

A PostgreSQL major version is usually released once a year. For the next major version, which is 9.5, this probably will be in the second half of 2015. As PostgreSQL is an open source product everything that(…)

the fastest way to load 1m rows in postgresql

There have been several posts on how to load 1m rows into a database in the last days: Variations on 1M rows insert (1): bulk insert Variations on 1M rows(…)

getting started with postgres plus advanced server (4) – setting up the monitoring server

If you followed the first, second and the third post the current ppas infrastructure consists of a primary database, a hot standby database and a backup and recovery server. Now we will add(…)

getting started with postgres plus advanced server (3) – setting up a hot standby server

So, we have a ppas 94 database up and running and we have a backup server for backing up and restoring the database. Now it is time to additionally protect the database by setting(…)