From: Pietro Pugni <pietro.pugni@gmail.com>
To: Josh Krupka <jkrupka@gmail.com>
Cc: Aidan Van Dyk <aidan@highrise.ca>
Cc: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
Date: Fri, 3 Apr 2015 17:10:47 +0200
Message-ID: <4D51FE53-2614-4D5E-8657-79485BF7D6E0@gmail.com> (raw)
In-Reply-To: <CAB6McgWJYjXEWtycB0bo9G+abvE1nkhh259x4AZjOdutpGCfVw@mail.gmail.com>
References: <87131335.225702.1427941178942.JavaMail.root@fmed.uba.ar>
<FF467B8B-B371-4F0F-8027-AFFAA823DD7E@gmail.com>
<CAC_2qU9bZNZSGMMWJ+6XBMKBJze2EKS8Zu-rb8Mxz36ngna0vA@mail.gmail.com>
<2EBBCD54-D3C8-436F-AF73-84EEF258AB70@gmail.com>
<CAC_2qU_PT5feWdrhBQYyTUcCs5vaFMmattnFw+2dXZZUo3Da=Q@mail.gmail.com>
<76EF504C-06AF-471F-8BCD-AFD2B6F85178@gmail.com>
<CAB6McgWJYjXEWtycB0bo9G+abvE1nkhh259x4AZjOdutpGCfVw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Hi Josh,
> Did you already post the results of:
> cat /proc/sys/vm/zone_reclaim_mode
zone_reclaim_mode was set on 0 for all my tests. I’ve also set it to the other values (1, 2, 4) but there was no improvement. Tests results are the following (1 run for each test):
echo 0 > /proc/sys/vm/zone_reclaim_mode
130s
echo 1 > /proc/sys/vm/zone_reclaim_mode
129s
echo 2 > /proc/sys/vm/zone_reclaim_mode
134s
echo 4 > /proc/sys/vm/zone_reclaim_mode
131s
> Also, how big did you say your dataset is? Based on the output of free, you're certainly not using all the memory you have. That could be just because you haven't accessed that much of your dataset, or it could be because zone reclaim is preventing you from using your entire amount of RAM as file system cache.
The table I use for this test is about 20milion row, has less than 10 columns (a small table) and has 4 indexes. Other tables I use are partitioned and consists of a total of 1.6bilion rows, 757 million rows ad so on descending.
Thank you for your help.
Best regards,
Pietro
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pietro.pugni@gmail.com, jkrupka@gmail.com, aidan@highrise.ca
Subject: Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
In-Reply-To: <4D51FE53-2614-4D5E-8657-79485BF7D6E0@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox