Some members of the Greenplum Community Forum have been asking about how to install on Greenplum CE a very useful “contrib” module available for PostgreSQL. We have prepared a slightly...
This week’s water falling from the skies isn’t turning into snow. And on days when it’s clear, my car is covered with tree pollen. While they means something different to...
We are proud to announce that 2ndQuadrant Deutschland (Germany) officially is registered. As opening bargain … We offer 11 different German PostgreSQL trainings, workshops and crash courses between March and...
Following up on last month’s Tuning Linux for low PostgreSQL Latency, there’s now been a giant pile of testing done on two filesystems, three patches, and two sets of kernel...
Lots of PostegreSQLer also use MySQL. Lots of MySQLer want to use PostgreSQL too. You are MySQLer and want to get more knowledge about PostgreSQL? 2ndQuadrant and me are planning...
One of the challenges when dealing with a new database design is that you don’t know things like how big the tables will end up being until they’re actually populated...
This week’s flame war on the pgsql-performance list once again revolves around the fact that PostgreSQL doesn’t have the traditional hint syntax available in other databases. There are a mix...
One of the ugly parts of Linux with PostgreSQL is that the OS will happily cache up to around 5% of memory before getting aggressive about writing it out. I’ve...
One of the more useful bits of PostgreSQL documentation I ever worked on is Tuning Your PostgreSQL Server. When that was written in the summer of 2008, a few months...
For a long time, adding packages to RedHat derived Linux systems has been called “RPM Hell”, for good reason. Particularly before the yum utility came about to help, getting RPM...
