Re: Performance problems with 8.1.1 compared to 7.4.7 - Mailing list pgsql-performance

From Frank Wiles
Subject Re: Performance problems with 8.1.1 compared to 7.4.7
Date
Msg-id 20051227125656.5d138645.frank@wiles.org
Whole thread Raw
In response to Re: Performance problems with 8.1.1 compared to 7.4.7  (Albert Cervera Areny <albert@sedifa.com>)
List pgsql-performance
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
 ---------------------------------


pgsql-performance by date:

Previous
From: Albert Cervera Areny
Date:
Subject: Re: Performance problems with 8.1.1 compared to 7.4.7
Next
From: Michael Stone
Date:
Subject: Re: What's the best hardver for PostgreSQL 8.1?