pjanuario commented on issue #3685: URL: https://github.com/apache/polaris/issues/3685#issuecomment-3876980130
FYI, just reinforcing, although that applying the indexes reduced the operation to 50% of the response, this unblocked us on the of the workloads (with 11k namespaces) but not the other one with (26k namespaces). I think the main culprit is this as the database can't create a decent query plan and this would also show a correlation between the number of namespaces and the tuples. > Observation: Namespace create operation triggers a query with a massive IN clause containing ~7,800 tuples: WHERE (catalog_id, id) IN ((?,?), (?,?)...) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
