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
