Run dispatch queries with preparedStatements

AcademySoftwareFoundation / OpenCue

A render management system you can deploy for visual effects and animation productions.

https://www.opencue.io

Apache License 2.0

833 stars 203 forks source link

Run dispatch queries with preparedStatements #1410

Closed DiegoTavares closed 4 months ago

DiegoTavares commented 4 months ago

Our experiments showed that running this query as a prepared statement makes Postgres more consistent in choosing a query plan to run based on the size of the underlying indexes.

No change in functionality is added by this change.

DiegoTavares commented 4 months ago

@bcipriano FYI