From: Alexey Vasiliev <leopard_ne@inbox.ru>
To: Shaun Thomas <sthomas@optionshouse.com>
Cc: 'Josh Berkus' <josh@agliodbs.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re[2]: [PERFORM] pgtune + configurations with 9.3
Date: Fri, 14 Nov 2014 17:23:56 +0300
Message-ID: <1415975036.62330340@f358.i.mail.ru> (raw)
In-Reply-To: <0683F5F5A5C7FE419A752A034B4A0B9797DA19EC@sswchi5pmbx2.peak6.net>
References: <CAEaSS0bLy8=1yVVbAH6us3m5d1tQ9obCxeHHeTU6vrqkggcN+g@mail.gmail.com>
<545BEFC2.1020203@agliodbs.com>
<0683F5F5A5C7FE419A752A034B4A0B9797DA19EC@sswchi5pmbx2.peak6.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Fri, 7 Nov 2014 14:13:20 +0000 от Shaun Thomas <sthomas@optionshouse.com>:
>> 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 performance guidelines 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 (pgsql-performance@postgresql.org)
>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 think I 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 someone can provide it? Because this generator should be valid for most users.
Thanks.
---
Alexey Vasiliev
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: leopard_ne@inbox.ru, sthomas@optionshouse.com, josh@agliodbs.com
Subject: Re: Re[2]: [PERFORM] pgtune + configurations with 9.3
In-Reply-To: <1415975036.62330340@f358.i.mail.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox