Re: Fine tuning mem sort, shared buffer

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/


--
  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