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
On Mon, Feb 4, 2019 at 6:07 PM suganthi Sekar <suganthi@xxxxxxxxxxxx> 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
