Re: restoring dum fast on one machine much slower on others

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Robert,

maybe different disk io systems? SSD vs. rotating rust? RAID vs. single spinning disk? Different disk caching behavior? Different command lines? fsync turned off on the fast box, maybe (please don't...)?

HTH

Johannes Lochmann

-----Ursprüngliche Nachricht-----
Von: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] Im Auftrag von robert rottermann
Gesendet: Thursday, 17 November, 2016 8:19 AM
An: pgsql-admin@xxxxxxxxxxxxxx
Betreff:  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@xxxxxxxxxxxxxx) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux