Campbell, Lance wrote: > Next the person would press a button, “generate”, found below the > questions. The JavaScript HTML page would then generate content for two > Iframes at the bottom on the page. One Iframe would contain the > contents of the postgresql.conf file. The postgresql.conf settings > would be tailored more to the individuals needs than the standard > default file. The second Iframe would contain the default settings one > should consider using with their operating system. > Man, it's not that easy. :-) Mainly because you will need some database activity. For example, work_mem, checkpoint_segments, and checkpoint_timeout depends on the database's dynamic. Database are not that static so another idea is to build a piece of software that monitors the database and do the modifications based on some observations (log, stats, etc). Don't forget that some of these options need a restart. So maybe your tool just advise the DBA that he/she could change option X to Y. Such a tool was proposed later [1] but it's not up to date. :(
[1] http://pgfoundry.org/projects/pgautotune/ -- Euler Taveira de Oliveira http://www.timbira.com/ ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
