The only time you really need to upgrade a fuel pump is when your engine starves for fuel under high loads. If you have your foot in it and you go through the gears without any surging, popping or backfiring (lean pops), then you shouldn't "need" a bigger fuel pump.
If however you nail your throttle and you are able to go through 1st gear, then 2nd gear, and then have it start surging and popping in 3rd, that is a good indicator that your pump isn't keeping up with how much fuel your engine needs.
When you nail it hard you use the fuel is stored in the carb flaot bowls through the lower gears, and when that runs out (usually about the time you hit high gear), the pump can't keep up so the carb goes dry and the engine begins to surge and pop.
Sometimes it's nice just to have a great looking pump on there, such as a new Edelbrock pump to insure you have good fuel flow and so it looks really nice, but most stock pumps do fine for most mild performance engines.