| From: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
|---|---|
| To: | Nicola Contu <nicola(dot)contu(at)gmail(dot)com>, Alban Hertroys <haramrae(at)gmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Centos 6.9 and centos 7 |
| Date: | 2017-12-04 16:44:49 |
| Message-ID: | f249b1c3-a561-d5b5-1e6a-2c5d826f1451@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Day, David | 2017-12-04 18:15:14 | RE: attempting to retrieve column names from information schema fails. |
| Previous Message | Tom Lane | 2017-12-04 16:08:15 | Re: attempting to retrieve column names from information schema fails. |