Re: Performance problems with 8.1.1 compared to 7.4.7

On Tue, 27 Dec 2005 19:02:17 +0100
Albert Cervera Areny <albert(at)sedifa(dot)com> 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(at)wiles(dot)org>
http://www.wiles.org
---------------------------------