Re: Fine tuning mem sort, shared buffer - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: Fine tuning mem sort, shared buffer
Date
Msg-id 200201151655.g0FGted09648@candle.pha.pa.us
Whole thread Raw
In response to Fine tuning mem sort, shared buffer  (Jean-Christophe ARNU <jc.arnu@free.fr>)
List pgsql-admin
pgman wrote:
> Jean-Christophe ARNU wrote:
> > Hi all,
> >     First of all, I apologize for all these questions but my dba knowledges
> > are quite grounded :(
> >
> >     I would like to know if there is a reveipe, good RTFM, any thing else
> > to estimate/evaluate values for mem_sort and shared buffers.
>
> See my hardware performance tuning article on techdocs site:
>
>     http://techdocs.postgresql.org/
>
> Specifically:
>
>     http://www.ca.postgresql.org/docs/momjian/hw_performance/

These parameters are aslo discussed on in our documentation in the
"Performance" section.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-admin by date:

Previous
From: Jean-Christophe ARNU
Date:
Subject: Fine tuning mem sort, shared buffer
Next
From: Mirek Hankus
Date:
Subject: problems with pg_dump/pg_restore