MIME-Version: 1.0
Message-ID: 
 <trinity-0fb2c7c8-9eec-4aa3-b943-4cdfea6e2525-1608629485973@3c-app-gmx-bs15>
From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
Cc: psycopg@postgresql.org
Subject: Aw: Re: psycopg3, prepared statements
Content-Type: text/plain; charset=UTF-8
Date: Tue, 22 Dec 2020 10:31:26 +0100
Importance: normal
Sensitivity: Normal
In-Reply-To: 
 <CAMqTPq=G1E=b32JxNo6dGk1-9qGHSCP7Puo5FCqf68nakiBo_Q@mail.gmail.com>
References: 
 <CA+mi_8aAuORkdXZ9bG_GpU34iPCGktMO83ktn+ODjL+Y=Y=e3Q@mail.gmail.com>
 <25a137a0-9ad3-bb9f-b008-263dcc81a645@aklaver.com>
 <CA+mi_8YoZ6_0NM4TbfqE8SQY8-b=RgaBH-jUVxzbWQdp+4oZGQ@mail.gmail.com>
 <331f273f-fc13-8d80-b209-c94c0960268b@aklaver.com>
 <CAMqTPq=G1E=b32JxNo6dGk1-9qGHSCP7Puo5FCqf68nakiBo_Q@mail.gmail.com>
Content-Transfer-Encoding: quoted-printable
Precedence: bulk

=C2=A0
>> - if more than `connection=2Eprepared_number` queries are prepared, the=
> one
>> used least recently is deallocated and evicted from the cache
>> (proposed default: 100)=2E
=C2=A0
>Why do you need such logic? Why not just keep some limited number of
>prepared statements? Is it a problem if a PS is in cache but rarely used?

On resource constrained environments one wants to be
able to balance use vs disuse=2E

Here I agree with Adrian: automagic, yes but only if one can
opt out by default=2E

Karsten
=C2=A0