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

Add infrastructure for test suites that run parallel queries on the same table #177

Closed
Ngalstyan4 opened this issue Sep 25, 2023 · 0 comments · Fixed by #192
Closed

Add infrastructure for test suites that run parallel queries on the same table #177

Ngalstyan4 opened this issue Sep 25, 2023 · 0 comments · Fixed by #192

Comments

@Ngalstyan4
Copy link
Contributor

We should have stress tests such as:

We concurrently insert into the database from 4 clients, we query from another 3 clients and we do some misc. things from another client (e.g. alter table add column, create additional index, drop/add index).

We can calculate some invariants to check in the end, in the regression test. e.g. number of total rows in the table, result of a query after all this load is done.

We can achieve this with pg_regress. To do that we just should avoid creating a separate DB for each test and should instead use pg_regress like most people usually use it.

I am open to keeping current tests intact and just adding a new mechanism for running this kinds of tests. I am open to other suggestions as well.

@Ngalstyan4 Ngalstyan4 changed the title Add infrastructure for parallel tests Add infrastructure for test suits that run parallel queries on the same table Sep 25, 2023
@Ngalstyan4 Ngalstyan4 changed the title Add infrastructure for test suits that run parallel queries on the same table Add infrastructure for test suites that run parallel queries on the same table Sep 25, 2023
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

Successfully merging a pull request may close this issue.

2 participants