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

From: Alexey Vasiliev
Subject: Re[2]: [PERFORM] pgtune + configurations with 9.3
Date: ,
Msg-id: 1415975036.62330340@f358.i.mail.ru
(view: Whole thread, Raw)
In response to: Re: pgtune + configurations with 9.3  (Shaun Thomas)
Responses: Re: pgtune + configurations with 9.3  (Shaun Thomas)
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, 7 Nov 2014 14:13:20 +0000 от Shaun Thomas <>:
>> Yeah, pgTune is pretty badly out of date.  It's been on my TODO list, as
>> I'm sure it has been on Greg's.
>
>Yeah. And unfortunately the recommendations it gives have been spreading. Take a look at the online version:
>
>http://pgtune.leopard.in.ua/
>
>I entered a pretty typical 92GB system, and it recommended 23GB of shared buffers. I tried to tell the author the
performanceguidelines have since changed, but it didn't help. 
>
>
>______________________________________________
>
>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


Hello, author of http://pgtune.leopard.in.ua/ is here.

I think everyone can do pull request to it. Old one take 25% for shared_buffers and 75% for effective_cache_size. I
thinkI can even add selector with version of postgresql (9.0 - 9.4) and in this case change formulas for 9.4 (for
example).

But I don't know what type of calculation should be in this case. Does we have in some place this information? Or
someonecan provide it? Because this generator should be valid for most users. 

Thanks.
---
Alexey Vasiliev

pgsql-performance by date:

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