ads' corner

PgConf.Russia 2016

I had the honor to present at PgConf.Russia 2016. It’s probably the biggest PostgreSQL conference in Europe (News report), even bigger than pgconf.eu. It shows that PostgreSQL, and Open Source in general, has a big and growing market share.¬†Was the first time that I travelled to Russia, and as with almost every new country, it is incredible. Also it is nice to be not in charge for a conference, and to enjoy the time attending talks, discuss with others or get stuff done.


Greenplum Database is Open Source

As promised earlier this year, Pivotal released the code for Greenplum Database into Open Source.

Greenplum Database is based on PostgreSQL (was forked from PG 8.2), and features a massive parallel processing system (MPP) to run SQL queries on very large data sets. The code base is licensed under the Apache 2.0 license, and available on GitHub. You can fork the project from there, or submit patches and new features.


CPU Usage in Pivotal Greenplum Database

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


Moving back to EMC

Beginning of February 2014 I moved back from goPivotal to EMC.


How to not export data in Ispirer SQLWays

Ispirer SQLWays is a nice (although commercial) tool to convert DDL and data from one supported database to another. We are using it regularly, the list of supported databases is impressive: PostgreSQL, Greenplum, Oracle, SQL Server, IBM DB2, MySQL, Sybase, Informix, Teradata, *Netezza *and some more.

There’s just one thing which I always forget: SQLways exports all data by default, which makes the export unnecessary big and slow.


Greenplum Community Edition - Connections from the host system into the virtual machine

If you download the Greenplum Community Edition (GP CE) from the Greenplum website and if you want to connect tools like pgAdminIII from your host machine to the database inside the virtual machine, you have to disable the firewall. The CE is installed on CentOS and by default the firewall is enabled and blocks connections from outside to most ports.

Here are the steps which are required to disable the firewall:


CHAR(11)

Was the first time that I actually had the chance to attend CHAR(11). For various reasons (speak: my wife had tickets for a musical) I could not attend last year.