Re: pgtune + configurations with 9.3

От: Shaun Thomas
Тема: Re: pgtune + configurations with 9.3
Дата: ,
Msg-id: 0683F5F5A5C7FE419A752A034B4A0B9797DCD4DA@sswchi5pmbx2.peak6.net
(см: обсуждение, исходный текст)
Ответ на: [PERFORM] pgtune + configurations with 9.3  (Alexey Vasiliev)
Ответы: Re[2]: [PERFORM] pgtune + configurations with 9.3  (Alexey Vasiliev)
Re: pgtune + configurations with 9.3  (Mark Kirkwood)
Список: pgsql-performance

Скрыть дерево обсуждения

pgtune + configurations with 9.3  (Tory M Blue, )
 Re: pgtune + configurations with 9.3  (Albe Laurenz, )
 Re: pgtune + configurations with 9.3  (Josh Berkus, )
  Re: pgtune + configurations with 9.3  (Shaun Thomas, )
   Re[2]: [PERFORM] pgtune + configurations with 9.3  (Alexey Vasiliev, )
    Re: pgtune + configurations with 9.3  (Shaun Thomas, )
     [PERFORM] pgtune + configurations with 9.3  (Alexey Vasiliev, )
      Re: pgtune + configurations with 9.3  (Shaun Thomas, )
       Re[2]: [PERFORM] pgtune + configurations with 9.3  (Alexey Vasiliev, )
        Re: Re[2]: [PERFORM] pgtune + configurations with 9.3  (Stuart Bishop, )
       Re: pgtune + configurations with 9.3  (Mark Kirkwood, )
        Re: pgtune + configurations with 9.3  (Jim Nasby, )
         Re: pgtune + configurations with 9.3  (Mark Kirkwood, )
        Re: pgtune + configurations with 9.3  (Stuart Bishop, )
         Re: pgtune + configurations with 9.3  (Johann Spies, )
 Re: pgtune + configurations with 9.3  (Johann Spies, )
  Re: pgtune + configurations with 9.3  (Johann Spies, )

Alexey,

The issue is not that 8GB is the maximum. You *can* set it higher. What I'm saying, and I'm not alone in this, is that
settingit higher can actually decrease performance for various reasons. Setting it to 25% of memory on a system with
512GBof RAM for instance, would be tantamount to disaster. A checkpoint with a setting that high could overwhelm pretty
muchany disk controller and end up  completely ruining DB performance. And that's just *one* of the drawbacks. 



______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email



В списке pgsql-performance по дате сообщения:

От: Mark Kirkwood
Дата:
Сообщение: Re: pgtune + configurations with 9.3
От: Jim Nasby
Дата:
Сообщение: Re: updating statistics on slow running query