Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YfXZl-0007vN-0k for pgsql-performance@arkaria.postgresql.org; Tue, 07 Apr 2015 17:46:13 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YfXZk-00082H-Go for pgsql-performance@arkaria.postgresql.org; Tue, 07 Apr 2015 17:46:12 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YfXZj-000829-Il for pgsql-performance@postgresql.org; Tue, 07 Apr 2015 17:46:11 +0000 Received: from mail-wi0-x230.google.com ([2a00:1450:400c:c05::230]) by makus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YfXZg-0000B8-De for pgsql-performance@postgresql.org; Tue, 07 Apr 2015 17:46:09 +0000 Received: by widdi4 with SMTP id di4so26587641wid.0 for ; Tue, 07 Apr 2015 10:46:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=content-type:mime-version:subject:from:in-reply-to:date:cc :message-id:references:to; bh=2e5fyAelXuQrlsWMeXxwbPKGDc6vdFma8tuPIPWcMpI=; b=KF5A3CL3cijozlEJ14AIX2006dGeuPiSOCJnwRywcZvjq9+JRnwIVOLa46HRcUQNvN 1tKUAyMWg2lrzflQd7L+qFdNBvmE6F6ubx8JKkaqMKmSPCeikU+l/y3AylhJrrWZVav2 AeHDOAKzWei6EPgQTllRe4XWguBPpwPrq8xcD2Vhr0zzu76Vt1QUYuGw262nS5HZUEsA maP5/5Ni5jhtEFojnK4fZrxksvdgQxIIjS1gVYEc0e6BiwbR1QPp5/7FBeewg3Hqyj+x +6U3Td0guXJ+0s3DM2aESE8phGB+Zr95vUw/2n8+0NBQVK5xNoHPK4g0XSiDR6mqtgRs wiww== X-Received: by 10.180.88.131 with SMTP id bg3mr6805917wib.71.1428428766709; Tue, 07 Apr 2015 10:46:06 -0700 (PDT) Received: from [192.168.2.2] (2-230-140-245.ip202.fastwebnet.it. [2.230.140.245]) by mx.google.com with ESMTPSA id gt4sm11960294wib.21.2015.04.07.10.46.05 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Tue, 07 Apr 2015 10:46:05 -0700 (PDT) Content-Type: multipart/alternative; boundary="Apple-Mail=_BF696E25-5962-48D9-8F8E-35F39DFA4305" Mime-Version: 1.0 (Mac OS X Mail 7.3 \(1878.6\)) Subject: Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL From: Pietro Pugni In-Reply-To: Date: Tue, 7 Apr 2015 19:45:58 +0200 Cc: PostgreSQL Performance Message-Id: References: <732B95A3-FEC8-4623-9AC5-98FD30F00863@gmail.com> <2F18FF84-5408-4AE8-9F2B-9110F76DED86@gmail.com> <5CC78F3A-8FD3-447F-8AB3-98BE80658E79@gmail.com> <051212BE-A86B-4874-8BAC-18F609DE8229@gmail.com> To: Jeff Janes X-Mailer: Apple Mail (2.1878.6) X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --Apple-Mail=_BF696E25-5962-48D9-8F8E-35F39DFA4305 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 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). =20 > 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. >=20 > 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=3DUTF8 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=92ll do some testing. In the meanwhile I=92ve made some kernel changes = which may help in heavy workloads (at the moment they don't affect = performance). I should offer you a dinner=85 Thank you a lot. Now I=92m looking to push it faster (I think it can = goes faster than this!). Best regards, Pietro= --Apple-Mail=_BF696E25-5962-48D9-8F8E-35F39DFA4305 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=windows-1252 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=3DUTF8

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=92ll do some testing. In the meanwhile I=92ve made = some kernel changes which may help in heavy workloads (at the moment = they don't affect performance).

I should offer = you a dinner=85
Thank you a lot. Now I=92m looking to push it = faster (I think it can goes faster than = this!).

Best = regards,
 Pietro
= --Apple-Mail=_BF696E25-5962-48D9-8F8E-35F39DFA4305--