On Tue, 27 Dec 2005 19:02:17 +0100 Albert Cervera Areny <albert@xxxxxxxxxx> wrote: > Are there any "rules of thumb" to let a begginer give reasonable > values to these parameters? Not only work_mem, but also > random_page_cost, and so on. Are there any tests one can run to > determine "good" values? > Hi Albert, There are several online sites that have information related to tuning parameters. Here is a list of a few of them: http://revsys.com/writings/postgresql-performance.html http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html http://www.powerpostgresql.com/Docs http://www.powerpostgresql.com/PerfList Hope these help! --------------------------------- Frank Wiles <frank@xxxxxxxxx> http://www.wiles.org ---------------------------------
