Re: PostgreSQL conf parameter setting

From: Jan Keirse <jan(dot)keirse(at)tvh(dot)com>
To: Jimit Amin <jimitamin9(at)gmail(dot)com>
Cc: Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL conf parameter setting
Date: 2015-08-18 11:47:43
Message-ID: CAH=XL3dChfsZujOEQyjCRaB=qFaJch2Cd_UVscbZxvfQhaEQPw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Aug 18, 2015 at 1:00 PM, Jimit Amin <jimitamin9(at)gmail(dot)com> wrote:
> Can I know normal, aggressive, best parameter settings for PostgreSQL.conf
> file for particular hardware.
>
> Like Linux x86_64 , 8 GB Ram
> , Linux x86_64 , 126 GB Ram

There's no generic answer because it depends on what you're doing with
the database, but this may offer a starting point:
http://pgtune.leopard.in.ua/

--

**** DISCLAIMER ****

http://www.tvh.com/glob/en/email-disclaimer

"This message is delivered to all addressees subject to the conditions
set forth in the attached disclaimer, which is an integral part of this
message."

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-08-18 13:32:59 Re: How to get cursor query
Previous Message Masahiko Sawada 2015-08-18 11:40:10 Re: Upgrade from postgresql-9.5alpha1 to postgresql-9.5alpha2 (Debian packages)