Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1c7IVa-0004MT-SJ for pgsql-admin@arkaria.postgresql.org; Thu, 17 Nov 2016 08:57:26 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1c7IVa-0007NX-6S for pgsql-admin@arkaria.postgresql.org; Thu, 17 Nov 2016 08:57:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1c7ITt-0005I9-On for pgsql-admin@postgresql.org; Thu, 17 Nov 2016 08:55:41 +0000 Received: from susanne.redcor.ch ([178.63.103.72]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1c7ITm-0005Mc-Qk for pgsql-admin@postgresql.org; Thu, 17 Nov 2016 08:55:41 +0000 Received: from [10.42.0.140] (hermes [46.140.116.238]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: robert@redcor.ch) by susanne.redcor.ch (Postfix) with ESMTPSA id 99D2DA01D5; Thu, 17 Nov 2016 09:55:33 +0100 (CET) Subject: Re: restoring dum fast on one machine much slower on others To: Johannes Lochmann , "pgsql-admin@postgresql.org" References: <412bd5e6-27f9-d8e5-7ba0-311e8960e7f2@redcor.ch> From: robert rottermann Message-ID: Date: Thu, 17 Nov 2016 09:55:32 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.4.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -4.8 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On 17.11.2016 08:44, Johannes Lochmann wrote: > Hi Robert, > > maybe different disk io systems? SSD vs. rotating rust? RAID vs. single spinning disk? thanks, very similar hardware.. chaching left as configured by ubuntu. > Different disk caching behavior? Different command lines? fsync turned off on the fast box, maybe (please don't...)? but if this is the case, should this not be reflected in the config files found in /etc/postgresql/9.5/main/*? robert > > HTH > > Johannes Lochmann > > -----Ursprüngliche Nachricht----- > Von: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] Im Auftrag von robert rottermann > Gesendet: Thursday, 17 November, 2016 8:19 AM > An: pgsql-admin@postgresql.org > Betreff: [ADMIN] restoring dum fast on one machine much slower on others > > 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 > -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin