Postgres Pro
Downloads
Home   >   mailing lists

Fwd: Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One - Mailing list pgsql-general

From Sébastien Boutté
Subject Fwd: Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One
Date
Msg-id CAOP64UoCUHVdJsOmq2exKzg3hPzD7Af0vS0uk-ZwNR-DAeoTYQ@mail.gmail.com
Whole thread Raw
In response to Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One  (Sébastien Boutté <sebastien.boutte@gmail.com>)
Responses Re: Fwd: Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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/





Attachment

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Recurring and non recurring events.
Next
From: Adrian Klaver
Date:
Subject: Re: Fwd: Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One