> ""Campbell, Lance"" <lance@xxxxxxxx> wrote in message > news:A3AC4FA47DC0B1458C3E5396E685E63302395E67@xxxxxxxxxxxxxxxxxxxxxxx > Now I am at the difficult part, what parameters to calculate and how to > calculate them. Everything below has to do with PostgreSQL version 8.2: > > > The parameters I would think we should calculate are: > max_connections > shared_buffers > work_mem > maintenance_work_mem > effective_cache_size > random_page_cost > > Any other variables? I am open to suggestions. I know this is mainly about tuning for performance but I do think you ought to give the option to change at least 'listen_address'. Something like: Accept connections on: - Local connections (Unix sockets/localhost) - All TCP/IP interfaces - Specific IP addresses: ___________ (comma-seperated list) and maybe a pointer to the pg_hba.conf docs for further info. Regards, Ben
