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

Enhancement request: disable pg_stat_statements when running anything but validation #8559

Open
itrofimow opened this issue Nov 19, 2023 · 0 comments

Comments

@itrofimow
Copy link
Contributor

HI!

It can be seen in hardware stats of continuous runs (https://tfb-status.techempower.com/) that top-performing frameworks are actually bottlenecked by the database backend in some tests (namely, queries and updates): for example, ntex, which tops multiple queries test with impressive 34k RPS, is idle ~30-35% of the time (click 4 -> somewhere in the middle of the list -> total_cpu_usage).

Obviously pg_stat_statements is not the problem in itself, however it does consume some database resources, and freeing these resource could in turn help put a bit more load on the framework under measurement.

So what i propose is to disable pg_stat_statements PostgreSQL extension right after the framework passes validation (afaik the extension is only used in validation).

@itrofimow itrofimow changed the title Enhancement request: disable pg_stat_statements when runing anything but validation Enhancement request: disable pg_stat_statements when running anything but validation Nov 19, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants