ads' corner

Google Summer of Code 2020 started

The PostgreSQL Project participates in Google Summer of Code (GSoC) 2020, with 3 projects. After the “Community Bonding” period finished last week, we are now in the active development phase - “Coding” as Google calls it. All three projects make good progress!


Local cachíng of Ansible Facts

Every time Ansible runs a Playbook, the first step (by default) is gathering facts about the target system:


Ansible: copy a directory recursive - take two

Another slow attempt at copying directories and files on a remote system from one place to another, using just Ansible operations.


Google Summer of Code 2019 - PostgreSQL participates with 5 projects

For the 13th year, the PostgreSQL Project is participating in Google Summer of Code (GSoC). This project is a great opportunity to let students learn about Open Source projects, and help them deliver new features. It is also a chance to engage the students beyond just one summer, and grow them into active contributors.


Ansible: copy a directory recursive

Recently I was looking for a way to copy a directory with all subdirectories, using Ansible. For reasons beyond this post I couldn’t use the synchronize (rsync) module. So I had to find a way to copy everything with basic Ansible steps.

That is possible, but it requires several steps, and it is very slow. Up to the point where it is not practical to use this approach for more than a few files and directories. Nevertheless, before moving on to another solution, I thought I document the steps here.


How long will a 64 bit Transaction-ID last in PostgreSQL?

At FOSDEM someone asked how long 64 bit Transaction-IDs will last.

To refresh: PostgreSQL is currently using 32 bits for the TXID, and is good for around 4 billion transactions:


CPU Usage in Pivotal Greenplum Database

Blogged about how Pivotal Greenplum Database is using all available CPU resources when executing queries.


PGCon 2011 - Second day

Second - and last day - of PGCon 2011 is over. It was a very good conference, I got new ideas and learned a lot.


Second day of PGDay.Eu 2010

The second conference day started with stress: the schedule was wrong in the booklet, the first talks in the morning were scheduled with 20 minutes instead of 50 minutes. This was the reason why so many visitors showed up early ;-) We decided to cut the next talks 5 minutes short and take 5 or 10 minutes from the breaks. After lunch we were back on schedule again.


PostgreSQL Schulung als Bildungsurlaub - 03.-07.05.2010 in Magdeburg

Die Volkshochschule Magdeburg wird im nächsten Semester wiederum einen Kurs PostgreSQL im Unternehmenseinsatz anbieten. Dieser Kurs vermittelt alle wichtigen Grundlagen zur Installation, Konfiguration, Administration und Performance Optimierung.