Postgres Pro
Downloads
Home   >   mailing lists

Thread: PostgreSQL conf parameter setting

PostgreSQL conf parameter setting

From
Jimit Amin
Date:

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

Re: PostgreSQL conf parameter setting

From
Jan Keirse
Date:
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."