From: | didier <did447(at)gmail(dot)com> |
---|---|
To: | Pietro Pugni <pietro(dot)pugni(at)gmail(dot)com> |
Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL |
Date: | 2015-04-02 15:11:41 |
Message-ID: | CAJRYxuKGW543ZdaZ3xmRVePo7Q=2xebv0NCo5qTejCv6UoZvvA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi
On Thu, Apr 2, 2015 at 3:52 PM, Pietro Pugni <pietro(dot)pugni(at)gmail(dot)com> wrote:
>
> I’ve searched just now what a collation is because I’ve never explicitly
> used one before, so I think it uses the default one.
>
>
> What's the output of free and sysctl -a | grep vm.zone_reclaim_mode
>
> Search the mailing list for zone_reclaim_mode there's some tips.
>
> vm.zone_reclaim_mode = 0
In my understanding it's the rigth value
there's also huge page
/sys/kernel/mm/transparent_hugepage/enabled
can you try to disable it?
Also test on the dell:
select tmp.cf, tmp.dt from grep_studi.tmp;
and
select tmp.cf, tmp.dt from grep_studi.tmp order by tmp.cf;
in Query B_2
the sort is 9 time slower on the dell, you have to find why...
>
> For testing you can also use the mac mini config with the dell, at
> least it should give you the same plan.
> With your example disks don't seem to matter, it's all in memory.
> T420 with optimal postgresql.conf
> Query B_1 [55999.649 ms + 0.639 ms] http://explain.depesz.com/s/LbM
> Query B_2 [95664.832 ms + 0.523 ms] http://explain.depesz.com/s/v06
>
>
> T420 with MacMini postgresql.conf
> Query B_1 [51280.208ms + 0.699ms] http://explain.depesz.com/s/wlb
> Query B_2 [177278.205ms + 0.428ms] http://explain.depesz.com/s/rzr
>
32 GB for buffers is too high for the queries in your test but it
doesn't matter.
> MacMini
> Query B_1 [56315.614 ms] http://explain.depesz.com/s/uZTx
> Query B_2 [44890.813 ms] http://explain.depesz.com/s/y7Dk
>
From | Date | Subject | |
---|---|---|---|
Next Message | Pietro Pugni | 2015-04-03 13:43:02 | Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL |
Previous Message | Pietro Pugni | 2015-04-02 14:25:03 | Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL |