Changes between Version 1 and Version 2 of Ticket #34255, comment 17
- Timestamp:
- Jan 26, 2023, 7:35:45 PM (22 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #34255, comment 17
v1 v2 1 1 I agree with Tim, having a bit more documentation on the known limitations/bugs of server-side binding (we should probably create an issue to track the group by one or maybe use #34262 with a dual purpose) and [https://medium.com/engineering-at-birdie/puzzling-postgres-a-story-of-solving-an-unreproducible-performance-issue-778075ed7998 its gotchas] which have ties to the usage of prepared statements (#20516). 2 2 3 FWIW I was surprised to learn that `psycopg>=3` also [https://www.psycopg.org/psycopg3/docs/advanced/prepare.html#prepared-statements prepares statement automatically on the fifth execution] which might result in unexpected behaviour. I'm not sure if this is the case when client-side binding is used though .3 FWIW I was surprised to learn that `psycopg>=3` also [https://www.psycopg.org/psycopg3/docs/advanced/prepare.html#prepared-statements prepares statement automatically on the fifth execution] which might result in unexpected behaviour. I'm not sure if this is the case when client-side binding is used though, I assume not as that requires the usage of server-side bindings? 4 4 5 5 All that to say that we should probably have a section with a summary of what to expect when switching to `psycopg>=3` and enabling server-side binding and maybe advertise the support as ''experimental'' for this first release?