Postgres Pro
Downloads
Home   >   mailing lists

Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL - Mailing list pgsql-performance

From Pietro Pugni
Subject Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
Date
Msg-id F0F4AB87-761B-46EF-AC47-3B13B706818C@gmail.com
Whole thread Raw
In response to Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL  (Pietro Pugni <pietro.pugni@gmail.com>)
List pgsql-performance
Tree view
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

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Some performance testing?
Next
From: Mel Llaguno
Date:
Subject: Re: Some performance testing?