Re: Parallel Seq Scan - Mailing list pgsql-hackers

From Fabrízio de Royes Mello
Subject Re: Parallel Seq Scan
Date
Msg-id CAFcNs+pOUEYC4PN4O_hUctHP=NM0=nJK14dBGnX=KY-HM17shg@mail.gmail.com
Whole thread Raw
In response to Re: Parallel Seq Scan  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: Parallel Seq Scan
List pgsql-hackers


 
I think one thing we could do minimize the chance of such an
error is set the value of parallel workers to be used for plan equal
to max_worker_processes if parallel_seqscan_degree is greater
than max_worker_processes.  Even if we do this, still such an
error can come if user has registered bgworker before we could
start parallel plan execution.


Can we check the number of free bgworkers slots to set the max workers?

Regards,

Fabrízio Mello 
 


--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Misaligned BufferDescriptors causing major performance problems on AMD
Next
From: Robert Haas
Date:
Subject: Re: Parallel Seq Scan