From: | Ilya Kosmodemiansky <ilya(dot)kosmodemiansky(at)postgresql-consulting(dot)com> |
---|---|
To: | Pietro Pugni <pietro(dot)pugni(at)gmail(dot)com> |
Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL |
Date: | 2015-04-01 14:27:20 |
Message-ID: | CAG95seWrfjHFwQEtn=0D-k0ex+Ag7cbOuFuaz4jgMhC9NJxp=A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi Pietro,
On Wed, Apr 1, 2015 at 3:56 PM, Pietro Pugni <pietro(dot)pugni(at)gmail(dot)com> wrote:
> T420: went from 311seconds (default postgresql.conf) to 195seconds doing
> tuning adjustments over RAID, kernel and postgresql.conf;
> MacMini: 40seconds.
I'am afraid, the matter is, that PostgreSQL is not configured properly
(and so do operating system and probably controller, however
pg_test_fsync shows that things are not so bad there as with
postgresql.conf).
It is pretty useless to benchmark a database using out-of-the-box
configuration. You need at least configure shared memory related,
checkpoints-related and autovacuum-related settings. And as a first
step, please compare postgresql.conf on Mac and on the server:
sometimes (with some mac installers) default postgresql.conf can be
not the same as on server.
Best regards,
Ilya
--
Ilya Kosmodemiansky,
PostgreSQL-Consulting.com
tel. +14084142500
cell. +4915144336040
ik(at)postgresql-consulting(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Aidan Van Dyk | 2015-04-01 14:32:00 | Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL |
Previous Message | Pietro Pugni | 2015-04-01 13:56:59 | Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL |