pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: robert rottermann <robert@redcor.ch>
To: pgsql-admin@postgresql.org
Subject: restoring dum fast on one machine much slower on others
Date: Thu, 17 Nov 2016 08:18:50 +0100
Message-ID: <412bd5e6-27f9-d8e5-7ba0-311e8960e7f2@redcor.ch> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

Hi there,
I run several Ubuntu boxes (at home, office, laptop ..)
at on box restoring a dump from a live server takes some 10 sec, on all other it 
takes minutes.

Just now I run Ubuntu 16.04 on all boxes, but this behaviour was the same with 
older versions.
I did compare all files in /etc/postgresql/9.5/main/*
They show no differences.

What could be the reason for this behaviour.
As I use this several times a day, I much prefer that faster load :)

thanks for your help
robert




-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



view thread (3+ messages)  latest in thread

Message-ID: <412bd5e6-27f9-d8e5-7ba0-311e8960e7f2@redcor.ch>
Permalink:  ../412bd5e6-27f9-d8e5-7ba0-311e8960e7f2@redcor.ch/
Also on:    postgresql.org/message-id/412bd5e6-27f9-d8e5-7ba0-311e8960e7f2@redcor.ch

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: robert@redcor.ch
  Subject: Re: restoring dum fast on one machine much slower on others
  In-Reply-To: <412bd5e6-27f9-d8e5-7ba0-311e8960e7f2@redcor.ch>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox