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 <leopard_ne@inbox.ru>) |
Ответы |
Re[2]: [PERFORM] pgtune + configurations with 9.3
Re: pgtune + configurations with 9.3 |
Список | pgsql-performance |
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 по дате отправления: