| From: | Josef Šimánek <josef(dot)simanek(at)gmail(dot)com> |
|---|---|
| To: | David Gauthier <davegauthierpg(at)gmail(dot)com> |
| Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Estimated resources for a 500 connections instance (VM) |
| Date: | 2020-04-07 16:28:50 |
| Message-ID: | CAFp7QwqxhiFNyug+EMYOAzyGA11QJ9RD11O5OedW_zizTm0bew@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello.
Have you checked
https://wiki.postgresql.org/wiki/Number_Of_Database_Connections?
For raw estimations you can also check http://pgconfigurator.cybertec.at/
or https://pgtune.leopard.in.ua/#/.
út 7. 4. 2020 v 18:25 odesílatel David Gauthier <davegauthierpg(at)gmail(dot)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 !
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Don Seiler | 2020-04-07 16:41:35 | Re: Mixed Locales and Upgrading |
| Previous Message | David Gauthier | 2020-04-07 16:24:33 | Estimated resources for a 500 connections instance (VM) |