> On 4 Dec 2017, at 16:57, Nicola Contu wrote:
>
> No I did not run a vacuum analyze. Do you want me to try with that first?
That means your statistics may not be up to date, although by now autovacuum
should have done the job (you didn't turn that off or anything, did you?). Bad
statistics r
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 perfor
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:
Did you run ANALYZE on your tables before the test?
On 4 December 2017 at 16:01, Tomas Vondra wrote:
>
> On 12/04/2017 02:19 PM, Nicola Contu wrote:
> ...>
>> centos 7 :
>>
>> dbname=# \timing Timing is on. cmdv3=# SELECT id FROM
>> client_billing_account WHERE name = 'name'; id --- * (1
On 12/04/2017 02:19 PM, Nicola Contu wrote:
...>
> centos 7 :
>
> dbname=# \timing Timing is on. cmdv3=# SELECT id FROM
> client_billing_account WHERE name = 'name'; id --- * (1 row)
> Time: 3.884 ms
>
> centos 6.9
>
> dbname=# SELECT id FROM client_billing_account WHERE name = 'name';
To make a better testing, I used a third server.
This is identical to the centos 7 machine, and it is not included in the
replica cluster.
Nobody is accessing this machine, this is top :
top - 14:48:36 up 73 days, 17:39, 3 users, load average: 0.00, 0.01, 0.05
Tasks: 686 total, 1 running, 685
These are the timings in centos 7 :
Time: 4.248 ms
Time: 2.983 ms
Time: 3.027 ms
Time: 3.298 ms
Time: 4.420 ms
Time: 2.599 ms
Time: 2.555 ms
Time: 3.008 ms
Time: 6.220 ms
Time: 4.275 ms
Time: 2.841 ms
Time: 3.699 ms
Time: 3.387 ms
These are the timings in centos 6:
Time: 1.722 ms
Time: 1.670 ms
centos 7 :
Time: 3.884 ms
centos 6.9
Time: 1.620 ms
Is there anything you can advice to solve or identify the problem?
Can you run this query 10 times on each server and note the timings?
I'd like to see the reproducability of this.
Also: both machines are otherwise idle (check with top o
Hello,
we recently upgrade OS from centos 6.9 to a new server with centos 7.
The centos 6.9 server has became the preproduction server now.
We are running postgres 9.6.6 on both servers.
They are both on SSD disk, these are the only differences :
- DB partition on centos 7 is on a RAID 10
- fil
