:yes:I would recommend reading the manufactures recommendations for tip size for what ever primer or paint you use. If you are using old school lacquer primer you will need a tip with a small opening. I would not recommend lacquer primer because it tends to shrink back and could show your bodywork later on. High build two part primers like polyester and urethane primers are much thicker and would need a larger opening tip. These primers are like a spay on body filler and give much better results with little to no shrinkage. Again check with the manufactures recommendations or ask the paint supplier you are using.
The same can be said for base coats and clear coats, read the manufacturers directions for tip size . The type of gun should not make a difference as long as it is functioning properly. That being said a HVLP gun will put more of the product on your car and not into the air and I would recomment a HVLP as well. good luck!