Skip site navigation (1) Skip section navigation (2)

Re: Performance problems with 8.1.1 compared to 7.4.7

From: Frank Wiles <frank(at)wiles(dot)org>
To: Albert Cervera Areny <albert(at)sedifa(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance problems with 8.1.1 compared to 7.4.7
Date: 2005-12-27 18:56:56
Message-ID: 20051227125656.5d138645.frank@wiles.org (view raw or flat)
Thread:
Lists: pgsql-performance
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
 ---------------------------------


In response to

pgsql-performance by date

Next:From: Michael StoneDate: 2005-12-27 19:05:16
Subject: Re: What's the best hardver for PostgreSQL 8.1?
Previous:From: Albert Cervera ArenyDate: 2005-12-27 18:02:17
Subject: Re: Performance problems with 8.1.1 compared to 7.4.7

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group