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

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(dot)boutte(at)gmail(dot)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/
>
>
>
>>
>