On Tue, 27 Dec 2005 19:02:17 +0100 Albert Cervera Areny <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> http://www.wiles.org --------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
