Optimal rates and adaptation for Bayesian methods of diffusion processes