Re: Fine tuning mem sort, shared buffer

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Fine tuning mem sort, shared buffer
Дата
Msg-id 200201151655.g0FGted09648@candle.pha.pa.us
обсуждение исходный текст
Ответ на Fine tuning mem sort, shared buffer  (Jean-Christophe ARNU <jc.arnu@free.fr>)
Список 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 по дате отправления:

Предыдущее
От: Jean-Christophe ARNU
Дата:
Сообщение: Fine tuning mem sort, shared buffer
Следующее
От: Mirek Hankus
Дата:
Сообщение: problems with pg_dump/pg_restore