PostgreSQL conf parameter setting

Started by Jimit Aminover 10 years ago2 messagesgeneral
Jump to latest
#1Jimit Amin
jimitamin9@gmail.com

Dear all,

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

Thanks and Regards
Jimit Amin

#2Jan Keirse
jan.keirse@tvh.com
In reply to: Jimit Amin (#1)
Re: PostgreSQL conf parameter setting

On Tue, Aug 18, 2015 at 1:00 PM, Jimit Amin <jimitamin9@gmail.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."

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general