On 12/04/2017 04:57 PM, Nicola Contu wrote: > No I did not run a vacuum analyze. Do you want me to try with that first? > > @Tomas: > Talking abut power management, I changed the profile for tuned-adm > to latency-performance instead of balanced (that is the default) > > that is increasing performances for now and they are similar to centos 6.9. > > Time: 2.121 ms > Time: 2.026 ms > Time: 1.664 ms > Time: 1.749 ms > Time: 1.656 ms > Time: 1.675 ms > > Do you think this can be easily done in production as well? > How am I supposed to know? Not only that depends on your internal deployment policies, but it's also much more a CentOS/RedHat question than PostgreSQL. regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
