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: Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One
Date: 2015-12-26 16:16:10
Message-ID: CAOP64UoQ0oOffDEhAbLByLZ4_4A-x5+-zJLBq5eMwRuw7G9esg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 Db installer with installation and data files
stored in user's home.
Third One : Compiled Version Postgres with executable and data files stored
in user's home.

All versions are 9.4.5.

My Backup is : 414 MB (Directory Archive)

Postgresql.conf modifications for all cases:
shared_buffers = 512MB
work_mem = 128MB # min 64kB
maintenance_work_mem = 512MB # min 1MB
fsync = off # turns forced synchronization on or off
synchronous_commit = off # synchronization level;
full_page_writes = off # recover from partial page writes
wal_buffers = 1024
checkpoint_segments = 64 # in logfile segments, min 1, 16MB each
checkpoint_timeout = 5min # range 30s-1h
checkpoint_completion_target = 0.9 # checkpoint target duration, 0.0 - 1.0
checkpoint_warning = 30s # 0 disables

Same Command for restore : pg_restore -d xxxx -j 4 -F d -U yyy -W backup

First One : Restore Time 1min53
Second One : Restore Time 3min48
Third One : Restore Time 2min51

I check files, encoding but i have not found any misconfiguration
parameters.

What do i have to do to have the same performance in the first and the
third ?
Is a problem with :
User Space / Kernel Space ?
Compilations options ?
LD Library ?
Missing something ?

Thanks you for your help

Sebastien Boutte

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-12-26 17:38:32 Re: Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One
Previous Message Kevin Waterson 2015-12-26 12:03:30 Re: Recurring and non recurring events.