When is it to much?

Is there a point when the size of the pagefile can be counter productive by making it to large? I’ve maxed out a few workstations in my domain at 4095MB to try to increase proformance, does this help or hurt the overall need for a faster production machine?