Re: PostgreSQL Configuration Tool for Dummies

> ""Campbell, Lance"" <lance(at)uiuc(dot)edu> wrote in message
> news:A3AC4FA47DC0B1458C3E5396E685E63302395E67(at)SAB-DC1(dot)sab(dot)uiuc(dot)edu(dot)(dot)(dot)
> 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