Open SlavaChristin opened 1 month ago
Thank you for the report. We intend on to benchmark these two approaches together with the new approach we use in ndc-postgres and get a better understanding on how to improve the situation for v3.
For v2, we don't plan to prioritize this at the moment, however it is likely that this problem can be mitigated using Native Queries if necessary.
We have a performance issue with a query that runs against large table
All database indexes are in place and data is in shared memory. The database we use is postgres 14.x and we use hasura/graphql-engine:v2.41.0.cli-migrations-v2 docker image
The performance issue appears when $isin parameter has 10k+ or more items
so the query runs for 2+ minutes
if the code inside ANY is replaced from array to a list of values like in the query below the results comes in subsecond
The solution is described in the article here https://www.datadoghq.com/blog/100x-faster-postgres-performance-by-changing-1-line/
It would be cool to incorporate this into harusa connector