På mandag 04. februar 2019 kl. 15:45:30, skrev Prince Pathria <
prince.path...@goevive.com <mailto:prince.path...@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
