Postgres Pro
Downloads
Home   >   mailing lists

Resource optimization - Mailing list pgsql-admin

From Daulat
Subject Resource optimization
Date
Msg-id CALfOM6KFrVnY2MpaNdJt72gD-fNB0D97cLxu6Qibr=q7f6NuuA@mail.gmail.com
Whole thread Raw
List pgsql-admin
Tree view
Hello Team,

How we can identify a suitable value for RAM and CPU in Postgres. 

- If the Postgres server has some small size of databases but high I/O .

- If database size is in TB's, high value for max_connections and high I/O
- 
Do we have any thumb rule in Postgres to decide these values?

Please advise !

Thanks.

pgsql-admin by date:

Previous
From: "Dischner, Anton"
Date:
Subject: AW: postgresql long running query
Next
From: Kevin Tu
Date:
Subject: Query a role's permission on a function