[PERFORM] pgtune + configurations with 9.3

От: Alexey Vasiliev
Тема: [PERFORM] pgtune + configurations with 9.3
Дата: ,
Msg-id: 1415983219.686386092@f34.i.mail.ru
(см: обсуждение, исходный текст)
Ответ на: Re: pgtune + configurations with 9.3  (Shaun Thomas)
Ответы: Re: pgtune + configurations with 9.3  (Shaun Thomas)
Список: pgsql-performance

Скрыть дерево обсуждения

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 16:28:16 +0000 от Shaun Thomas <>:
> Alexey,
>
> The issue is that the 1/4 memory suggestion hasn't been a recommendation in quite a while. Now that much larger
amountsof RAM are readily available, tests have been finding out that more than 8GB of RAM in shared_buffers has
diminishingor even worse returns. This is true for any version. Further, since PostgreSQL manages its own memory, and
theLinux Kernel also manages various caches, there's significant risk of storing the same memory both in
shared_buffers,and in file cache. 
>
> There are other tweaks the tool probably needs, but I think this, more than anything else, needs to be updated. Until
PGsolves the issue of double-buffering (which is somewhat in progress since they're somewhat involved with the Linux
kerneldevs) you can actually give it too much memory. 
>
>
> ______________________________________________
>
> 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
>

Several months ago I asked question in this channel "Why shared_buffers max is 8GB?". Many persons said, what this is
apocrypha,what 8GB is maximum value for shared_buffers. This is archive of this chat:
http://www.postgresql.org/message-id/

What is why so hard to understand what to do with pgtune calculation.

--
Alexey Vasiliev

В списке pgsql-performance по дате сообщения:

От: Alexey Vasiliev
Дата:
Сообщение: Re[2]: [PERFORM] pgtune + configurations with 9.3
От: Mark Kirkwood
Дата:
Сообщение: Re: pgtune + configurations with 9.3