pg_hint_plan
pg_hint_plan copied to clipboard
Question, looking for a way to turn off parallel query processing
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)*/