Re: Designing a better connection pool for psycopg3 - Mailing list psycopg

From Karsten Hilbert
Subject Re: Designing a better connection pool for psycopg3
Date
Msg-id YAXYLesS69X2o8s1@hermes.hilbert.loc
Whole thread Raw
In response to Re: Designing a better connection pool for psycopg3  (Vladimir Ryabtsev <greatvovan@gmail.com>)
List psycopg
Am Mon, Jan 18, 2021 at 10:20:12AM -0800 schrieb Vladimir Ryabtsev:

> > 'minconn', Proposed default: 4
> Many services and applications do not really need many connections
> but would like to benefit from automatic reconnections. So the default
> is questionable, as many people will leave it unchanged.

I would, perhaps, default to 1 *per thread*. Or to 2 per
thread, one readonly, and one readwrite, if the application
cares (requests ro vs rw, that is). But that's just me and my
use case :-)

Karsten
--
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B



psycopg by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: Designing a better connection pool for psycopg3
Next
From: Karsten Hilbert
Date:
Subject: Re: Designing a better connection pool for psycopg3