Optimizing PostgreSQL Connection Limits on Windows Server 2019: Balancing Performance and Stability
In our production environment, we are utilizing Windows Server 2019 with 4 cores and 4 threads. Currently, PostgreSQL is configured with a maximum connection limit of 150. However, there are requirements for it to support up to approximately 160 connections. What is the recommended maximum connections per core for PostgreSQL?