By being able to pass user defined object's in PL/pgSQL from python, this would allow for both a cleaner approach from the DB side, as well as the ability to have a performance optimization for large batch data processing.
If we are able to pass a collection as an input to the procedure from python, it would avoid running individual inserts on each row. In use-cases like pricing this will create bottlenecks in the process
spenechap444
commented
6 months ago
By being able to pass user defined object's in PL/pgSQL from python, this would allow for both a cleaner approach from the DB side, as well as the ability to have a performance optimization for large batch data processing.
If we are able to pass a collection as an input to the procedure from python, it would avoid running individual inserts on each row. In use-cases like pricing this will create bottlenecks in the process