Playr, PgSQL Scripts Released
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
Reindexing Concurrently
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
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.

