Unofficial pgCon 2008 Group Photo

Posted on May 24, 2008

Click for big sized
Click for Larger Version

Here are some misc pictures I took @ pgCon.

Playr, PgSQL Scripts Released

Posted on May 22, 2008

I've just created the 0.1 release tarballs for both Playr and our PgSQL Script bundle.

Playr is our log replay, PostgreSQL stress testing application and attempts to answer the question "How much headroom will our new server give us?" Our PgSQL Script bundle is just a hodgepodge collection of scripts which currently has two scripts we've developed for in-house use; concurrentReindex and parallelVacuum. Both "projects" are fairly new, use at your own risk.

Polaroid - Again

Posted on May 18, 2008
Received the new FLM3732 replacement unit on Thursday in a box that's far too flimsy to ship a television in, though there was adequate foam packing. The LCD has a "dark streak" in it, about 1" wide and about 10" high on the right side of the LCD. It's most noticeable against solid backgrounds, such as when I'm watching golf in 1080i. Round two for support to get a good replacement? I think I'll send my blog to the CEO of Polaroid.

Reindexing Concurrently

Posted on May 09, 2008

Index bloat can be a major pain in heavy OLTP databases. With Reindex being a blocking operation in Postgres, you can not reasonably reclaim index bloat in a large database by hand without going offline. Thus enter concurrentReindex.php. This PHP cli script will concurrently reindex all non-unique, non-system catalog indexes in a given database. I have only tested this against a Postgres 8.2 database, but it should work in theory against 8.2 or higher. Feedback, enhancements and patches welcome.

Another strike for Polaroid

Posted on May 03, 2008

Called up today to inquire to the status of the replacement TV and found out that a supervisor put the replacement on hold as of April 21st due to needing secondary confirmation from the technician beyond what they put in the computer. That was the last status update. I received no call from them. I couldn't imagine running a business the way that they seem to. I think the next step is figuring out how to best get the word out to never buy from Polaroid and documenting all of the calls, exchanges, broken promises and lack of support I have received in fixing my flat screen TV that was under warranty when it went bad.