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.bou...@gmail.com> 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? Yes > Core i5 2500K > 16G RAM > SSD 256Go > > > Is 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.ubuntu > Compiled Version : pg_config.compiled & pg_controldata.compiled > > > 2) Run each installations pg_controldata against the installation data > directory: > > /usr/local/pgsql/bin/pg_controldata /usr/local/pgsql/data/ > > > >> >
