Re: pgtune + configurations with 9.3

From: Shaun Thomas
Subject: Re: pgtune + configurations with 9.3
Date: ,
Msg-id: 0683F5F5A5C7FE419A752A034B4A0B9797DA19EC@sswchi5pmbx2.peak6.net
(view: Whole thread, Raw)
In response to: Re: pgtune + configurations with 9.3  (Josh Berkus)
Responses: Re[2]: [PERFORM] pgtune + configurations with 9.3  (Alexey Vasiliev)
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, )

> 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 by date:

From: David G Johnston
Date:
Subject: Re: Postgres does not use indexes with OR-conditions
From: Ruben Domingo Gaspar Aparicio
Date:
Subject: Postgres slave not catching up (on 9.2)