Fastest Backup Method?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-admin@xxxxxxxxxxxxxx
Subject: Fastest Backup Method?
From: Artem Tomyuk <admin@xxxxxxxxxxxxxx>
Date: Mon, 4 Sep 2017 20:23:30 +0300

Hi.

I'am wondering, what is the fastest backup method do you know, for me it is:

(Assume that we running on 16 * CPU box)

pg_dump -Z 4 -j 16 -F c -F d

-Z 4 compression level

-j 16 number of parallel jobs

-F c, d custom+directory format

Follow-Ups:
- Re: Fastest Backup Method?
  - From: Peter Eisentraut

Prev by Date: Re: New to postgreSQL
Next by Date: Re: pgdump and restore results in different sizes DB
Previous by thread: wal_level not changing
Next by thread: Re: Fastest Backup Method?
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux