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

Make use of the index while reading the config table #12

Open
gleu opened this issue Apr 20, 2023 · 2 comments
Open

Make use of the index while reading the config table #12

gleu opened this issue Apr 20, 2023 · 2 comments

Comments

@gleu
Copy link
Member

gleu commented Apr 20, 2023

Performance are really bad without :) See https://github.com/dalibo/pg_query_settings/wiki/Benchmarks

@tilkow
Copy link
Contributor

tilkow commented Jun 14, 2023

Hi Guillaume,

Here is a modest test with attempt to use SPI.

@gleu
Copy link
Member Author

gleu commented Jun 15, 2023

I did some tests last night. It seems to be working. The index is used, perfs don't move a bit if you have 1 to 500 configurations in the table. But, and this is a big one, performance are really bad. We have at least 30% less TPS. This is even worst than the 500-config test I did when we were scanning the whole table. I currently have no idea why, and no time to check. We'll have to understand what did go wrong. But at least, you finally found how to use the index, with is great. Kudos!

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

No branches or pull requests

2 participants