Aw: Re: psycopg3, prepared statements - Mailing list psycopg

From Karsten Hilbert
Subject Aw: Re: psycopg3, prepared statements
Date
Msg-id trinity-0fb2c7c8-9eec-4aa3-b943-4cdfea6e2525-1608629485973@3c-app-gmx-bs15
Whole thread Raw
In response to Re: psycopg3, prepared statements  (Vladimir Ryabtsev <greatvovan@gmail.com>)
List psycopg
 
>> - 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
 



psycopg by date:

Previous
From: Vladimir Ryabtsev
Date:
Subject: Re: psycopg3, prepared statements
Next
From: Daniele Varrazzo
Date:
Subject: Re: psycopg3, prepared statements