On 12/23/20 6:49 PM, Simon Riggs wrote:
The whole premise of the patch is tighter integration, with the server providing the facilities that poolers need.
I am all for that. Ideally I would want builtin connection pooling but short term I think the way forward is most likely tighter integration.
The patch can be enhanced to do whatever else we agree is desirable. Do we need something like DISCARD ALL EXCEPT PREPARED STATEMENTS; ?? If there are different requirements for each pooler, what are they?
If someone adds prepared statement support to e.g. PgBouncer that might be a nice feature to have. Plus maybe something like "SET transaction_cleanup = 'except_prepared'". But right now I think the pools which support prepared statements do not use DISCARD ALL and instead just trust the end user to not run SET or use temporary tables which outlive transactions.
Andreas
