Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres large database backup - Mailing list pgsql-general

From Mladen Gogala
Subject Re: postgres large database backup
Date
Msg-id 303273b8-6116-23b2-f26d-866e38ef1c0a@gmail.com
Whole thread Raw
In response to Re: postgres large database backup  (Hannes Erven <hannes@erven.at>)
Responses Re: postgres large database backup  (Michael Loftis <mloftis@wgops.com>)
List pgsql-general
Tree view
On 11/30/22 18:19, Hannes Erven wrote:
You could also use a filesystem that can do atomic snapshots - like ZFS.

Uh, oh. Not so sure about that. Here is a page from the world of the big O: https://blog.docbert.org/oracle-on-zfs/

However, similar can be said about ZFS. ZFS snapshots will slow down the I/O considerably. I would definitely prefer snapshots done in hardware and not in software.  My favorite file systems, depending on the type of disk, are F2FS and XFS. 

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

pgsql-general by date:

Previous
From: Hannes Erven
Date:
Subject: Re: postgres large database backup
Next
From: Michael Loftis
Date:
Subject: Re: postgres large database backup