"PGTune: calculate configuration for PostgreSQL based on the maximum performance for a given hardware configuration. It isn't a silver bullet for the optimization settings of PostgreSQL. Many settings depend not only on the hardware configuration, but also on the size of the database, the number of clients and the complexity of queries. An optimal configuration of the database can only be made given all these parameters are taken into account."
It's a nice tool thaqt I've been using for years and was surprised to find out that it wasn't posted yet on HN.
It's a nice tool thaqt I've been using for years and was surprised to find out that it wasn't posted yet on HN.