pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
restoring dum fast on one machine much slower on others
3+ messages / 2 participants
[nested] [flat]

* restoring dum fast on one machine much slower on others
@ 2016-11-17 07:18  robert rottermann <robert@redcor.ch>
  0 siblings, 1 reply; 3+ messages in thread

From: robert rottermann @ 2016-11-17 07:18 UTC (permalink / raw)
  To: pgsql-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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: restoring dum fast on one machine much slower on others
@ 2016-11-17 07:44  Johannes Lochmann <johannes.lochmann@topcontrol.it>
  parent: robert rottermann <robert@redcor.ch>
  0 siblings, 1 reply; 3+ messages in thread

From: Johannes Lochmann @ 2016-11-17 07:44 UTC (permalink / raw)
  To: pgsql-admin

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@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


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: restoring dum fast on one machine much slower on others
@ 2016-11-17 08:55  robert rottermann <robert@redcor.ch>
  parent: Johannes Lochmann <johannes.lochmann@topcontrol.it>
  0 siblings, 0 replies; 3+ messages in thread

From: robert rottermann @ 2016-11-17 08:55 UTC (permalink / raw)
  To: Johannes Lochmann <johannes.lochmann@topcontrol.it>; pgsql-admin



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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2016-11-17 08:55 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-11-17 07:18 restoring dum fast on one machine much slower on others robert rottermann <robert@redcor.ch>
2016-11-17 07:44 ` Johannes Lochmann <johannes.lochmann@topcontrol.it>
2016-11-17 08:55   ` robert rottermann <robert@redcor.ch>

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