I am setting up prod cluster and want to choose number of segments per host/node, how to decide this? And what is the benefits to have multiple primary segments (excluding mirror) per node?
Take a look at this guide... specifically page 22
https://gpdb.docs.pivotal.io/43100/pdf/Pivotal_Clustering_Concepts_A03.pdf
hope this helps..