Re: pgtune + configurations with 9.3 - Mailing list pgsql-performance

From Shaun Thomas
Subject Re: pgtune + configurations with 9.3
Date
Msg-id 0683F5F5A5C7FE419A752A034B4A0B9797DCD4DA@sswchi5pmbx2.peak6.net
Whole thread Raw
In response to [PERFORM] pgtune + configurations with 9.3  (Alexey Vasiliev <leopard_ne@inbox.ru>)
Responses Re[2]: [PERFORM] pgtune + configurations with 9.3  (Alexey Vasiliev <leopard_ne@inbox.ru>)
Re: pgtune + configurations with 9.3  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
List 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 by date:

Previous
From: Alexey Vasiliev
Date:
Subject: [PERFORM] pgtune + configurations with 9.3
Next
From: Alexey Vasiliev
Date:
Subject: Re[2]: [PERFORM] pgtune + configurations with 9.3