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

From: Sébastien Boutté <sebastien(dot)boutte(at)gmail(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Fwd: Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One
Date: 2015-12-26 21:36:14
Message-ID: CAOP64UoCUHVdJsOmq2exKzg3hPzD7Af0vS0uk-ZwNR-DAeoTYQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 Content-Type Size
pg_config.compiled application/octet-stream 1.4 KB
pg_config.ubuntu application/octet-stream 2.5 KB
pg_controldata.compiled application/octet-stream 2.1 KB
pg_controldata.ubuntu application/octet-stream 2.1 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-12-26 22:42:09 Re: Fwd: Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One
Previous Message Tom Lane 2015-12-26 20:15:50 Re: Recurring and non recurring events.