From: Andreas Joseph Krogh <andreas@visena.com>
To: pgsql-performance@lists.postgresql.org
Subject: Sv: Re: Fw: server hardware tuning.
Date: Mon, 4 Feb 2019 15:56:45 +0100 (CET)
Message-ID: <VisenaEmail.38.73d479ddee0ddb2c.168b900e5e0@tc7-visena> (raw)
In-Reply-To: <CAON0Day=M6164EehJo1M-CS95c22fpGrArm_pVwJ9tjzaRYujg@mail.gmail.com>
På mandag 04. februar 2019 kl. 15:45:30, skrev Prince Pathria <
prince.pathria@goevive.com <mailto:prince.pathria@goevive.com>>: Hi Suganthi, I
can give you a start, some pro users can suggest you better. 1. Don't use
this much of connections on a single postgres server. Use a connection pooler
in front of it. 2. RAM: Depends upon how much data you want to be cached. 3.
Use PCIe SATA SSD with RAID10, Postgres uses a lot of IO for its operations.
4. For config tuning: https://pgtune.leopard.in.ua/#/
<https://pgtune.leopard.in.ua/#/; Though please go through all params for more
understanding Happy to help :) Prince Pathria Systems Architect Intern Evive
+91 9478670472goevive.com <http://goevive.com; There's no such thing as PCIe
SATA, use PCIe or NVMe in RAID-10, it's quite affordable these days and
meaningless not to use. --
Andreas Joseph Krogh
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: andreas@visena.com, pgsql-performance@lists.postgresql.org
Subject: Re: Sv: Re: Fw: server hardware tuning.
In-Reply-To: <VisenaEmail.38.73d479ddee0ddb2c.168b900e5e0@tc7-visena>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox