Fine tuning mem sort, shared buffer

Поиск
Список
Период
Сортировка
Искать

Fine tuning mem sort, shared buffer

От:
Jean-Christophe ARNU <jc.arnu@free.fr>
Дата:
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

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
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

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
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
FAQ