June 3rd, 2010 |
Published in
Database, Tech Talk | No Comments
With the introduction of PostgreSQL 8.4, Bruce Momjian, a significant core developer, contributed a tool that can actually upgrade an entire database cluster in place. The time required is essentially only that necessary to copy the data files from the old installation to the new one. On a quick RAID system, this can be an order of magnitude faster than a dump/restore. The main drawback is similar to Slony: disk space must effectively be doubled for this upgrade method.
April 16th, 2010 |
Published in
Database, Tech Talk | 2 Comments
PostgreSQL can be both a beautiful thing, and an infuriating mess.
March 15th, 2010 |
Published in
Database | No Comments
Postgresql hates itself. I’m convinced of this, and have considered the idea frequently over the years. I roll it around in my mouth just to savor the taste, only to hope the flavor changes eventually. A couple things have advanced, though not quite what one might hope.
August 27th, 2008 |
Published in
Database, Programming, Rant, Tech Talk | 9 Comments
There’s a lot of debate in application development circles over various sundries such as column naming schemes and framework implementation details. Well, I’d like to clear all that up.
