pg_hint_plan icon indicating copy to clipboard operation
pg_hint_plan copied to clipboard

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

Open MironAtHome opened this issue 1 year ago • 0 comments

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)*/

MironAtHome avatar Sep 14 '24 15:09 MironAtHome