PostgreSQL can be both a beautiful thing, and an infuriating mess.
Occasionally I look through the logs on one of our database servers to see if I can’t optimize some queries. It’s good practice, and is an excellent way to monitor basic system performance by watching for queries that take longer than might otherwise be possible. Sometimes performance can be fixed by tweaking an index, or manually rewriting the query and convincing a developer to integrate the changes.
I kinda have a thing for Matt Tiabbi. I never would have expected a Rolling Stone columnist to constantly harangue and brutally deconstruct the players of the economic fiasco. Without remorse, restraint, or mercy, he absolutely eviscerates everything from Goldman Sachs and AIG to the current administration and everything in-between. It really is a thing of beauty, and one of the best reasons investigative journalism had better survive the media reorganization caused by the internet.
Well, maybe I spoke too soon about Drupal. Why? Well… it’s 2010 guys, stop with the ID links. I know there’s a plugin that overcomes this shortcoming, but all the internal links, including edits, redirects, and so on, won’t use the aliases you define. No, foo.bar.com/node/123423 is not a valid url. It requires approximately ten minutes to add a table column for a ‘slug’ to look up the appropriate entry, but Drupal refuses to compromise.
Jen suckered me into volunteering to help her music boosters with their choir contest this weekend. This entailed waking up at 4:45AM so we could leave at 5:30AM to finish setup and get ready for the festivities to begin at 8:00AM. Woo? My job description was Sound Technician for the day, where I handled four Sony voice recorders; three for the judges and one to record the choir. Each choir used between eight and twelve minutes for two or three songs, but each time block was twenty to act as a buffer between groups.
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.