RE: pg_basebackup is taking more time than expected

From: Kellner Thiemo <thiemo(dot)kellner(at)usb(dot)ch>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: RE: pg_basebackup is taking more time than expected
Date: 2018-01-15 15:35:23
Message-ID: 63eaa2ce382444899be8d26986cb2263@usb.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> According to our previous discussion, pg_basebackup is not depend on any of the postgresql configuration parameters. If I 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 load penalty. I suggest you experiment with setups. Maybe --compress is doing still well with respect to compression rate but consumes considerably less CPU time.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2018-01-15 17:13:41 Re: why SSD is slower than HDD SAS 15K ?
Previous Message David G. Johnston 2018-01-15 15:12:10 Re: pg_basebackup is taking more time than expected