Re: Estimated resources for a 500 connections instance (VM)

2020-04-08 Thread Laurenz Albe
On Tue, 2020-04-07 at 15:51 -0400, David Gauthier wrote: > But for my edification, is it roughly true that 2 connections working with > the DB 100% > of the time is equivalent to 20 connections @ 10% = 200 connections @ 1 % (if > you know what I mean) ? Roughly, yes. There is a certain overhead,

Re: Estimated resources for a 500 connections instance (VM)

2020-04-07 Thread Rob Sargent
On 4/7/20 2:23 PM, Sándor Daku wrote: On Tue, 7 Apr 2020 at 21:52, David Gauthier > wrote: After looking at some of the factors that can affect this, I think it may be important to know that most of the connections will be almost idle (in terms of i

Re: Estimated resources for a 500 connections instance (VM)

2020-04-07 Thread Adrian Klaver
On 4/7/20 12:51 PM, David Gauthier wrote: After looking at some of the factors that can affect this, I think it may be important to know that most of the connections will be almost idle (in terms of interacting with the DB).  The "users" are perl/dbi scripts which connect to the DB and spend th

Re: Estimated resources for a 500 connections instance (VM)

2020-04-07 Thread Tim Cross
David Gauthier writes: > After looking at some of the factors that can affect this, I think it may > be important to know that most of the connections will be almost idle (in > terms of interacting with the DB). The "users" are perl/dbi scripts which > connect to the DB and spend the vast majo

Re: Estimated resources for a 500 connections instance (VM)

2020-04-07 Thread Sándor Daku
On Tue, 7 Apr 2020 at 21:52, David Gauthier wrote: > After looking at some of the factors that can affect this, I think it may > be important to know that most of the connections will be almost idle (in > terms of interacting with the DB). The "users" are perl/dbi scripts which > connect to the

Re: Estimated resources for a 500 connections instance (VM)

2020-04-07 Thread David Gauthier
After looking at some of the factors that can affect this, I think it may be important to know that most of the connections will be almost idle (in terms of interacting with the DB). The "users" are perl/dbi scripts which connect to the DB and spend the vast majority of the time doing things other

Re: Estimated resources for a 500 connections instance (VM)

2020-04-07 Thread Laurenz Albe
On Tue, 2020-04-07 at 12:24 -0400, David Gauthier wrote: > 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 > de

Re: Estimated resources for a 500 connections instance (VM)

2020-04-07 Thread Josef Šimánek
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 napsal: > psql (9.6.0, server 11.3) on linux >

Estimated resources for a 500 connections instance (VM)

2020-04-07 Thread David Gauthier
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 r