RE: pg_basebackup is taking more time than expected - Mailing list pgsql-general

From Kellner Thiemo
Subject RE: pg_basebackup is taking more time than expected
Date
Msg-id 63eaa2ce382444899be8d26986cb2263@usb.ch
Whole thread Raw
In response to Re: pg_basebackup is taking more time than expected  (Raghavendra Rao J S V <raghavendrajsv@gmail.com>)
List pgsql-general
> According to our previous discussion, pg_basebackup is not depend on any of the postgresql configuration parameters.
IfI go for gzip format we need to compromise on time.
 

You do not necessarily compromise on time when compressing. Actually, a speed gain compared to uncompressed is
possible.The better data is being compressed the less has to be written on (slow) disk. However, it comes with a CPU
loadpenalty. I suggest you experiment with setups. Maybe --compress is doing still well with respect to compression
ratebut consumes considerably less CPU time.
 

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: pg_basebackup is taking more time than expected
Next
From: Vick Khera
Date:
Subject: Re: why SSD is slower than HDD SAS 15K ?