I manage to have the same performance between ubuntu package and compiled version ; just a few seconds of difference.
don't know what parameter i've missed i restart again and again ...
Sorry to have pollute the mailing list ;)
Thank you Adrian for the tips on pg_config and pg_controldata.
Good night
Sébastien Boutté
On Sat, Dec 26, 2015 at 10:34 PM, Sébastien Boutté <sebastien.boutte@xxxxxxxxx> wrote:
Honestly, not enough information to make a determination. So:
1) Is the order you show above the actual order you did the restores?No, i have made multiples tests but it's always the same order of nature.
2) Are the above timings from one run for each setup or multiple runs?
Multiple runs.
3) Just to be clear, this is all on the same machine, correct? YesCore i5 2500K16G RAMSSD 256GoIs a problem with :
User Space / Kernel Space ?
Compilations options ?
LD Library ?
Missing something ?
To see how each installation is set up you can:
1) Run the pg_config for each installation, so for instance, on a compiled version on my machine:
/usr/local/pgsql/bin/pg_config
i've attached config files for :Ubuntu Default : pgconfig.ubuntu & pg_controldata.ubuntuCompiled Version : pg_config.compiled & pg_controldata.compiled2) Run each installations pg_controldata against the installation data directory:
/usr/local/pgsql/bin/pg_controldata /usr/local/pgsql/data/
