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/#/ Though please go through all params for more understanding Happy to help :) Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com On Mon, Feb 4, 2019 at 6:07 PM suganthi Sekar <sugan...@uniphore.com> wrote: > > Hi , > > > I need know how to calculate hardware sizing for database or query > > > RAM > > CPU > > Config tuning > > > Requirement : > > > 1100 concurrent connection > > 1600 column of table > > 1GB of data can be select and dynamic aggregation will happen > > > Regards > > SuganthiSekar >
