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@sedifa.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@wiles.org>
   http://www.wiles.org
 ---------------------------------