I have been lucky enough to be invited at the marvellous PGDay.eu 2012 conference in Stuttgart, which ended just yesterday. The topic of the first of my two talks has been a collection of PostgreSQL objects that play chess, either between themselves or against a human.
2ndQuadrant will be delivering two courses on PostgreSQL in Australia. The location will be the prestigious Rialto Towers, one of the greatest attractions in Melbourne, right in the heart of the Central Business District, and one of the tallest office buildings in the world.
PostgreSQL development is now done with periodic pauses to review and commit patches that have been submitted, called Commit Fests. The patches themselves are stored on a custom web app, and documentation about the process is on the PostgreSQL wiki. I’m returning to the role of CommitFest manager for this one, which means I get […]
My tour this week of the PostgreSQL West conference has taught me that you can deliver three talks in two days, or you can have fun seeing other people’s talks, but it’s rather difficult to do both. You can also find the slides from Hannu’s talk on Django/Python database calls, which unfortunately he was too ill […]
Since I’ve already pushed my book here once on my blog this week, this version will be short and include two chunks of free (as in beer) content for you. My book covering PostgreSQL performance, from versions 8.1 to 9.0, is now available. Downloads of the 468 page e-book text are available immediately from Packt […]
If you’re looking for a heavy dose of information about PostgreSQL performance tuning, you’re going to find the next month very interesting. We at 2ndQuadrant have been working on two books about PostgreSQL 9.0 this year. You can pre-order those right now, and as I’m staring at a home printed copy of my PostgreSQL 9.0 […]
Whether or not you made it our CHAR(10) conference last month, you can now relive part of the experience by downloading the conference slides. Some of those were posted live during the conference, some showed up later, but almost everything is there now. Sadly, Nic Ferrier’s entertaining presentation about how WooMe (acquired by Zoosk) was scaled […]
Officially Greenplum Database Single Node Edition (SNE) is only installable on Red Hat Enterprise Linux (RHEL) and SUSE Linux Enteprise Server (SLES), but while surfing the web I have seen many requests on how to install it on Debian/Ubuntu. Here I’m trying to give you some advices.
One of the main reasons users switch from other relational databases to PostgreSQL is the advanced support for geographic objects included in the PostGIS extension. Being PostgreSQL specialists at 2ndQuadrant, we have tried to investigate if it was possible (and how) to install PostGIS on the Greenplum Single Node edition. Let’s see how Marco Nenciarini, […]
Last week at the CHAR(10) conference we had a workshop on “Cloud Databases”. To put it simply: what to do when the use case requirements exceed the resources available in the database server. This was a main topic of the whole conference, and several solutions have been illustrated during the day. A common theme has […]