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.
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.
A while back i blogged about a bug with PDO and prepared statements. After digging a little it appears that as of libpq.so.4 (PostgreSQL 8.0 tree) native prepared statement support was added. If PDO detects you have libpq.so.4 at compile time it will use the libpq prepare instead of its own internal prepare. What then happens is random prepared statements fail with heavy use. Again the only way around this right now is to use libpq.so.3 from PostgreSQL 7.4. Now to figure out who to bug about it. I have a feeling the PDO folks will point to libpq and the libpq maintainers will point to PDO.
