From: Pietro Pugni <pietro.pugni@gmail.com>
To: Jeff Janes <jeff.janes@gmail.com>
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: Tue, 7 Apr 2015 19:45:58 +0200
Message-ID: <F0F4AB87-761B-46EF-AC47-3B13B706818C@gmail.com> (raw)
In-Reply-To: <CAMkU=1wrMvuhxsE5D1P1xTv5muF7LVEh8LV6rMKrkR85p4=asQ@mail.gmail.com>
References: <732B95A3-FEC8-4623-9AC5-98FD30F00863@gmail.com>
<CAMkU=1wsRYdWrQ2m5wshTJw41wncOJeHXATxzVbCbYXbmoxTFQ@mail.gmail.com>
<2F18FF84-5408-4AE8-9F2B-9110F76DED86@gmail.com>
<CAMkU=1y2iifFf+EevByDdTouE+Yxc56Gs=t_-2ktCQ7OLhRzpQ@mail.gmail.com>
<5CC78F3A-8FD3-447F-8AB3-98BE80658E79@gmail.com>
<CAMkU=1wvEXOEtoiDM4M4_MTQ4aEG+rmBdbw19QLosvdDO1qH2w@mail.gmail.com>
<051212BE-A86B-4874-8BAC-18F609DE8229@gmail.com>
<CAMkU=1wrMvuhxsE5D1P1xTv5muF7LVEh8LV6rMKrkR85p4=asQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Hi Jeff
> The default collation for the database cluster is set when you create the cluster with initdb (the package you used to install postgresql might provide scripts that wrap initdb and call it something else, sorry I can't be much use with those).
> You can set it with --lc-collate flag to initdb, otherwise it is set based on the environment variables (LANG or LC_* variables) set in the shell you use to run initdb.
>
> Note that you can create a new database in the cluster which has its own default which is different from the cluster's default.
guess what? it worked! Now I run the following command:
/usr/local/pgsql/bin/initdb -D /mnt/raid5/pg_data --no-locale --encoding=UTF8
Time execution for my reference transaction went from 2m9s to 1m18s where Mac Mini is 1m43s.
This is the best improvement after modifying BIOS settings.
I’ll do some testing. In the meanwhile I’ve made some kernel changes which may help in heavy workloads (at the moment they don't affect performance).
I should offer you a dinner…
Thank you a lot. Now I’m looking to push it faster (I think it can goes faster than this!).
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, jeff.janes@gmail.com
Subject: Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
In-Reply-To: <F0F4AB87-761B-46EF-AC47-3B13B706818C@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