Postgres Pro
Downloads
Home   >   mailing lists

Re: Estimated resources for a 500 connections instance (VM) - Mailing list pgsql-general

From Josef Šimánek
Subject Re: Estimated resources for a 500 connections instance (VM)
Date
Msg-id CAFp7QwqxhiFNyug+EMYOAzyGA11QJ9RD11O5OedW_zizTm0bew@mail.gmail.com
Whole thread Raw
In response to Estimated resources for a 500 connections instance (VM)  (David Gauthier <davegauthierpg@gmail.com>)
List pgsql-general
Tree view

út 7. 4. 2020 v 18:25 odesílatel David Gauthier <davegauthierpg@gmail.com> napsal:
psql (9.6.0, server 11.3) on linux

We've ramped up usage on a PG server (a VM, I have no choice about this) and are approaching the 100 connections limit.  We could increase the limit, but I've read that this can lead to a degradation in performance. If we bump it up to 500, what kind of compute resources would that require (mem/cpu)?  Any estimates ?

Thanks ! 

pgsql-general by date:

Previous
From: David Gauthier
Date:
Subject: Estimated resources for a 500 connections instance (VM)
Next
From: Don Seiler
Date:
Subject: Re: Mixed Locales and Upgrading