Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Consider avoiding ubuquitous types in benchmark catalog queries #3961

Open
rbrw opened this issue Apr 9, 2024 · 1 comment
Open

Consider avoiding ubuquitous types in benchmark catalog queries #3961

rbrw opened this issue Apr 9, 2024 · 1 comment
Labels

Comments

@rbrw
Copy link
Contributor

rbrw commented Apr 9, 2024

At the moment, benchmark generates two different flavors of an exported resources query when --catalog-query-pct is positive. Both of these filter on the resource type, without any consideration of the frequency of that type. In some testing with larger system (simulating 100k nodes), the Service type was frequently chosen for the query, a type that was extremely common, matching 11m rows in catalog_resources, causing an expensive full table scan, and a very large result.

Consider adjusting benchmark somehow, to prefer more selective exported resource queries.

@rbrw rbrw added the triaged label Apr 9, 2024
Copy link

github-actions bot commented Apr 9, 2024

Migrated issue to PDB-5741

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant