logindpostgres is a script that reads SQL select
statements from PostgreSQL logs and generates all
the indices to optimize the database for each
request. It has been tested on 1.2 GB of logs.
Information regarding Project Releases and Project Resources. Note that the information here is a quote from Freecode.com page, and the downloads themselves may not be hosted on OSDN.