The software license PostgreSQL is released under makes it extremely friendly to businesses who would like to use the database in commercial products.  Partly as a result of this, a significant amount of PostgreSQL development is donated by companies who sell products derived from the database (even entire forks of the source code).  Normally this […]

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 with a fair amount of data.  But if the design has to factor in the eventual scalability concerns, you can’t deploy it to obtain that […]

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 after the release of PostgreSQL 8.3, it was hard to find any similar guide that was both (relatively) concise and current. Since then, myself and […]