Re[2]: [PERFORM] pgtune + configurations with 9.3

From: Alexey Vasiliev
Subject: Re[2]: [PERFORM] pgtune + configurations with 9.3
Date: ,
Msg-id: 1415992224.324747668@f354.i.mail.ru
(view: Whole thread, Raw)
In response to: Re: pgtune + configurations with 9.3  (Shaun Thomas)
Responses: Re: Re[2]: [PERFORM] pgtune + configurations with 9.3  (Stuart Bishop)
List: pgsql-performance

Tree view

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, )



Fri, 14 Nov 2014 17:06:54 +0000 от Shaun Thomas <>:
> 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 ()
> 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 by date:

From: Mark Kirkwood
Date:
Subject: Re: pgtune + configurations with 9.3
From: Jim Nasby
Date:
Subject: Re: updating statistics on slow running query