Aw: Re: psycopg3, prepared statements

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To:
Cc: psycopg(at)postgresql(dot)org
Subject: Aw: Re: psycopg3, prepared statements
Date: 2020-12-22 09:31:26
Message-ID: trinity-0fb2c7c8-9eec-4aa3-b943-4cdfea6e2525-1608629485973@3c-app-gmx-bs15
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
 

In response to

Browse psycopg by date

  From Date Subject
Next Message Daniele Varrazzo 2020-12-22 22:36:48 Re: psycopg3, prepared statements
Previous Message Vladimir Ryabtsev 2020-12-22 05:39:19 Re: psycopg3, prepared statements