Re: Is a connection max lifetime useful in a connection pool?

2021-02-21 Thread Julien Rouhaud
On Mon, Feb 22, 2021 at 7:52 AM Andres Freund wrote: > > On 2021-02-21 19:05:03 +0100, Daniele Varrazzo wrote: > > One of the HikariCP configuration parameters is "maxLifetime", whose > > description is: "This property controls the maximum lifetime of a > > connection in the pool. [...] **We stron

Re: Is a connection max lifetime useful in a connection pool?

2021-02-21 Thread Andres Freund
Hi, On 2021-02-21 19:05:03 +0100, Daniele Varrazzo wrote: > One of the HikariCP configuration parameters is "maxLifetime", whose > description is: "This property controls the maximum lifetime of a > connection in the pool. [...] **We strongly recommend setting this > value, and it should be severa

Re: Is a connection max lifetime useful in a connection pool?

2021-02-21 Thread Daniele Varrazzo
On Sun, 21 Feb 2021 at 19:12, Pavel Stehule wrote: > I have very strong experience - it is very useful. On Sun, 21 Feb 2021 at 19:26, Stephen Frost wrote: > Short answer- yes. Sounds good. Thank you very much for your insight! -- Daniele

Re: Is a connection max lifetime useful in a connection pool?

2021-02-21 Thread Stephen Frost
Greetings, * Daniele Varrazzo (daniele.varra...@gmail.com) wrote: > I am designing and implementing a connection pool for psycopg3 [1][2]. > Some of the inspiration is coming from HikariCP [3], a Java connection > pool. > > One of the HikariCP configuration parameters is "maxLifetime", whose > de

Re: Is a connection max lifetime useful in a connection pool?

2021-02-21 Thread Pavel Stehule
Hi ne 21. 2. 2021 v 19:05 odesílatel Daniele Varrazzo < daniele.varra...@gmail.com> napsal: > Hello, > > I am designing and implementing a connection pool for psycopg3 [1][2]. > Some of the inspiration is coming from HikariCP [3], a Java connection > pool. > > One of the HikariCP configuration pa

Is a connection max lifetime useful in a connection pool?

2021-02-21 Thread Daniele Varrazzo
Hello, I am designing and implementing a connection pool for psycopg3 [1][2]. Some of the inspiration is coming from HikariCP [3], a Java connection pool. One of the HikariCP configuration parameters is "maxLifetime", whose description is: "This property controls the maximum lifetime of a connect