No of partitions for a QP
Hi Team,
Read in some articles that the no of partitions for a QP by default is 5 from 8.7 version.
Can we still have the maximum partitions as 20?
What is the impact if we keep 5 or 20, Is it that if we have less throughput we should go with 5 and if we have more throughput we should go with 20?
And what will happen if we increase it beyond 20? Looks like it is a global setting and not specific to any QP ? Is there no way that we can have partitions based on the name of QP, like which QP needs better throughput we can make it 20 and other as 5
@ShwetaB96 A key word search on the MSP brings up this list of questions and this enhancement request.
One Partition can only be assigned to single thread. So irrespective of no of nodes, only 1 thread from 1 of 3 nodes will be processing the records, so just have number of thread per node on QP ruleform as 1 for this downsize test.
Did you already go through the documentation Understanding queue processors and Queue processor FAQ?
Also see Background Processing.
@_Lukasz_ is this something you could answer?