Postgres Pro
Downloads
Home   >   mailing lists

Thread: Fine tuning mem sort, shared buffer

Fine tuning mem sort, shared buffer

From
Jean-Christophe ARNU
Date:
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.

    Thank you.
--
Jean-Christophe ARNU
s/w developer
Paratronic France

Re: Fine tuning mem sort, shared buffer

From
Bruce Momjian
Date:
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

Re: Fine tuning mem sort, shared buffer

From
Bruce Momjian
Date:
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