Hi
On Thu, Apr 2, 2015 at 3:52 PM, Pietro Pugni 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 zon
Hi Tigran,
> The modern CPUs trying to be too smart.
>
> try to run this code to disable CPUs c-states:
>
> > setcpulatency.c
>
> #include
> #include
> #include
>
> int main(int argc, char **argv) {
> int32_t l;
> int fd;
>
> if (argc != 2) {
> fprintf(stderr, "Usage: %s \n
On Thu, Apr 2, 2015 at 9:23 AM, Pietro Pugni wrote:
> the command
> dmesg | grep -i numa
> doesn’t display me anything. I think T420 hasn’t NUMA on it. Is there a
> way to enable it from Ubuntu? I don’t have immediate access to BIOS (server
> is in another location).
>
NUMA stands for "Non-Unif
Il giorno 02/apr/2015, alle ore 14:29, didier ha scritto:
> Hi,
>
> On Thu, Apr 2, 2015 at 12:47 PM, Pietro Pugni wrote:
>> Hi Jeff,
>> thank you for your response.
>> I’m using Postgres 9.0 on MacMini because I’ve noticed that it’s quite fast
>> compared to different Ubuntu machines on which
Hi Aidan,
>
> T420
> work_mem = 512MB
>
> MacMini
> work_mem = 32MB
>
> So that is why the T420 does memory sorts and the mini does disk sorts.
>
> I'd start looking at why memory sorts on the T420 is so slow. Check your
> numa settings, etc (as already mentioned).
>
> For a drastic test
On Thu, Apr 2, 2015 at 6:33 AM, Pietro Pugni wrote:
> *T420*
> work_mem = 512MB
>
> *MacMini*
> work_mem = 32MB
>
So that is why the T420 does memory sorts and the mini does disk sorts.
I'd start looking at why memory sorts on the T420 is so slow. Check your
numa settings, etc (as already
Hi,
On Thu, Apr 2, 2015 at 12:47 PM, Pietro Pugni wrote:
> Hi Jeff,
> thank you for your response.
> I’m using Postgres 9.0 on MacMini because I’ve noticed that it’s quite fast
> compared to different Ubuntu machines on which I’ve worked with different
> (and more performant) hardware.
> The buil
Hi Pietro,
The modern CPUs trying to be too smart.
try to run this code to disable CPUs c-states:
> setcpulatency.c
#include
#include
#include
int main(int argc, char **argv) {
int32_t l;
int fd;
if (argc != 2) {
fprintf(stderr, "Usage: %s \n", argv[0]);
return 2;
Hi Ilya,
thank your for your response.
Both system were configured for each test I’ve done. On T420 I’ve optimized the
kernel following the official Postgres documentation (
http://www.postgresql.org/docs/9.4/static/kernel-resources.html ):
kernel.shmmax=68719476736
kernel.shmall=16777216
vm.over
Hi Wei Shan,
Thank you for your response.
Query B was run after initializing the DB ex-novo doing VACUUM ANALYZE before
and after creating and clustering indexes.
By the way, these results are consistent through time and are reproducible, so
it’s not a metter of statistic collector (I guess).
You
Hi Jeff,
thank you for your response.
I’m using Postgres 9.0 on MacMini because I’ve noticed that it’s quite fast
compared to different Ubuntu machines on which I’ve worked with different (and
more performant) hardware.
The built-in Postgres version on OS X Server is impossible to update. I shoul
Hi Gerardo,
thank you for your response.
At the moment I can’t switch to RAID10. I know it has best performance, but
both systems have RAID5 and MacMini has a consumer desktop RAID solution while
T420 has a server-grade one.
Anyway, I used two configurations for each system: one for data loading
12 matches
Mail list logo
