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...
I maintain a number of project whose purpose in life is to make testing portions of PostgreSQL easier. All of these got a decent upgrade over this last week. stream-scaling...
As the PostgreSQL Elephant continues its march toward yet another release, I’ve been thinking quite a bit about the role users of software should have in its user interface design...
When PostgreSQL 9.0 shipped a few months ago, it included several new replication features. It’s obvious that you can use these features to build clusters of servers for both high...
The time of being the PostgreSQL girl working for MySQL at Oracle is over now. Simon Riggs from 2ndQuadrant offered me a job that I couldn’t resist. So I closed...
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...
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...
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...
