Re[2]: [PERFORM] pgtune + configurations with 9.3
От | Alexey Vasiliev |
---|---|
Тема | Re[2]: [PERFORM] pgtune + configurations with 9.3 |
Дата | |
Msg-id | 1415992224.324747668@f354.i.mail.ru обсуждение исходный текст |
Ответ на | Re: pgtune + configurations with 9.3 (Shaun Thomas <sthomas@optionshouse.com>) |
Ответы |
Re: Re[2]: [PERFORM] pgtune + configurations with 9.3
|
Список | pgsql-performance |
Fri, 14 Nov 2014 17:06:54 +0000 от Shaun Thomas <sthomas@optionshouse.com>: > 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 thatsetting it higher can actually decrease performance for various reasons. Setting it to 25% of memory on a system with512GB of RAM for instance, would be tantamount to disaster. A checkpoint with a setting that high could overwhelm prettymuch any 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 > > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > Ok. Just need to know what think another developers about this - should pgtune care about this case? Because I am not sure,what users with 512GB will use pgtune. -- Alexey Vasiliev
В списке pgsql-performance по дате отправления: