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

Question, looking for a way to turn off parallel query processing #202

Open
MironAtHome opened this issue Sep 14, 2024 · 0 comments
Open

Comments

@MironAtHome
Copy link

MironAtHome commented Sep 14, 2024

Hello pg_hint_plan devs.
Question. I have a request, fairly simple.
My question, is there way to ensure single thread processing of a request.
Something, that other RDBMS support with similar to /*+ MAX_PARALLEL_PROCESSES 1 */
I was looking over regression tests and I did try
/*+Parallel(p1 1 hard)*/
but instead of single threaded processing got multi-thread plan with 1 thread working over the table, which made things only worse.
Found alternate hint, that looks good to me, could you please share if this is the correct approach?
/*+Set(max_parallel_workers_per_gather 0)*/

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

1 participant