Re: Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One

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/