Re: [GENERAL] Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One

2015-12-26 Thread Sébastien Boutté
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

Re: Fwd: [GENERAL] Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One

2015-12-26 Thread Adrian Klaver
On 12/26/2015 01:36 PM, Sébastien Boutté 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

Fwd: [GENERAL] Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One

2015-12-26 Thread Sébastien Boutté
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) J

Re: [GENERAL] Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One

2015-12-26 Thread Adrian Klaver
On 12/26/2015 08:16 AM, Sébastien Boutté wrote: Hi, For my project, to be able to easily manage postgres instance and version, i want to install it in user's directory and launch by user also. For my tests, I've got some issues with pg_restore on three differents installations. First One : Ubu

[GENERAL] Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One

2015-12-26 Thread Sébastien Boutté
Hi, For my project, to be able to easily manage postgres instance and version, i want to install it in user's directory and launch by user also. For my tests, I've got some issues with pg_restore on three differents installations. First One : Ubuntu 15.10 Default Package Second One : Enterprise