depends on a couple things, what is getting the air from the compressor to the gun by means of length of pipe and pipe size and how good your air filtering is. You do not want to run a little compressor loaded all the time because the air just gets hotter and hotter and heat is what creates the moisture. If you have a refrigerated air dryer that cools the air down past dew point consistently then a little one is fine. I like to run the biggest pipe I can reasonably put after the compressor with t fittings and drain valves to get moisture out, but those actually take cfm's away from the work.
If you can get a compressor to cycle on 5 or 6 times an hour, you are usually ok with heat and excess moisture buildup, but every three to five minutes is asking for trouble.