Re: limiting performance impact of wal archiving. - Mailing list pgsql-performance

From Ivan Voras
Subject Re: limiting performance impact of wal archiving.
Date
Msg-id hdbrv8$p35$1@ger.gmane.org
Whole thread Raw
In response to limiting performance impact of wal archiving.  (Laurent Laborde <kerdezixe@gmail.com>)
Responses Re: limiting performance impact of wal archiving.  (Laurent Laborde <kerdezixe@gmail.com>)
List pgsql-performance
Laurent Laborde wrote:
> Hi !
> We recently had a problem with wal archiving badly impacting the
> performance of our postgresql master.

Hmmm, do you want to say that copying 16 MB files over the network (and
presumably you are not doing it absolutely continually - there are
pauses between log shipping - or you wouldn't be able to use bandwidth
limiting) in an age when desktop drives easily read 60 MB/s (and besides
most of the file should be cached by the OS anyway) is a problem for
you? Slow hardware?

(or I've misunderstood the problem...)

pgsql-performance by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: limiting performance impact of wal archiving.
Next
From: Laurent Laborde
Date:
Subject: Re: limiting performance impact of wal archiving.