During EuroPython 2011, the major annual event for Python developers and users in Europe, 2ndQuadrant will deliver a special hands-on training session entitled “The Python and the Elephant”. This 4-hour...
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...
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...
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...
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...
If you have a Linux server of the RedHat family (inclusing CentOS and Fedora), you might envy the way Debian/Ubuntu distributions handle PostgreSQL clusters management. Although it is not easy...
