RE: pg_basebackup is taking more time than expected

Поиск
Список
Период
Сортировка
От Kellner Thiemo
Тема RE: pg_basebackup is taking more time than expected
Дата
Msg-id 63eaa2ce382444899be8d26986cb2263@usb.ch
обсуждение исходный текст
Ответ на Re: pg_basebackup is taking more time than expected  (Raghavendra Rao J S V <raghavendrajsv@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: pg_basebackup is taking more time than expected
Следующее
От: Vick Khera
Дата:
Сообщение: Re: why SSD is slower than HDD SAS 15K ?