The thermal paste is used to improve the interface between the CPU and the CPU cooler. It works by effectively ironing out any microscopic imperfections between the two surfaces to improve overall heat transfer efficiency. This reduces the temperature at which the CPU operates. A lower temperature allows for slower/quieter fans or better overclocking.
Specification varies depending on cooler chosen.