public inbox for [email protected]  

help / color / mirror / Atom feed

From: Karsten Hilbert <[email protected]>
Cc: [email protected]
Subject: Aw: Re: psycopg3, prepared statements
Date: Tue, 22 Dec 2020 10:31:26 +0100
Message-ID: <trinity-0fb2c7c8-9eec-4aa3-b943-4cdfea6e2525-1608629485973@3c-app-gmx-bs15> (raw)
In-Reply-To: <CAMqTPq=G1E=b32JxNo6dGk1-9qGHSCP7Puo5FCqf68nakiBo_Q@mail.gmail.com>
References: <CA+mi_8aAuORkdXZ9bG_GpU34iPCGktMO83ktn+ODjL+Y=Y=e3Q@mail.gmail.com>
	<[email protected]>
	<CA+mi_8YoZ6_0NM4TbfqE8SQY8-b=RgaBH-jUVxzbWQdp+4oZGQ@mail.gmail.com>
	<[email protected]>
	<CAMqTPq=G1E=b32JxNo6dGk1-9qGHSCP7Puo5FCqf68nakiBo_Q@mail.gmail.com>

 
>> - if more than `connection.prepared_number` queries are prepared, the> one
>> used least recently is deallocated and evicted from the cache
>> (proposed default: 100).
 
>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.

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

Karsten
 

view thread (13+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Aw: Re: psycopg3, prepared statements
  In-Reply-To: <trinity-0fb2c7c8-9eec-4aa3-b943-4cdfea6e2525-1608629485973@3c-app-gmx-bs15>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox