| 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: | Whole Thread | Raw Message | 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 |
| 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. |