Re: pgtune + configurations with 9.3

От: Shaun Thomas
Тема: Re: pgtune + configurations with 9.3
Дата: ,
Msg-id: 0683F5F5A5C7FE419A752A034B4A0B9797DA19EC@sswchi5pmbx2.peak6.net
(см: обсуждение, исходный текст)
Ответ на: Re: pgtune + configurations with 9.3  (Josh Berkus)
Ответы: Re[2]: [PERFORM] pgtune + configurations with 9.3  (Alexey Vasiliev)
Список: 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, )

> 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



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

От: David G Johnston
Дата:
Сообщение: Re: Postgres does not use indexes with OR-conditions
От: Ruben Domingo Gaspar Aparicio
Дата:
Сообщение: Postgres slave not catching up (on 9.2)