Postgres Pro
Downloads
Home   >   mailing lists

Re: file cloning in pg_upgrade and CREATE DATABASE - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: file cloning in pg_upgrade and CREATE DATABASE
Date
Msg-id CAEepm=37B7N_=jvh9TBP=h6eeGMQFaB3YAw-Ov9p7S1sNv_Z=w@mail.gmail.com
Whole thread Raw
In response to file cloning in pg_upgrade and CREATE DATABASE  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: file cloning in pg_upgrade and CREATE DATABASE  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
Tree view 
On Wed, Feb 21, 2018 at 4:00 PM, Peter Eisentraut
<peter.eisentraut@2ndquadrant.com> wrote:
> - XFS has (optional) reflink support.  This file system is probably more
> widely used than Btrfs.
>
> - Linux and glibc have a proper function to do this now.
>
> - APFS on macOS supports file cloning.

TIL that Solaris 11.4 (closed) ZFS supports reflink() too.  Sadly,
it's not in OpenZFS though I see numerous requests and discussions...
(Of course you can just clone the whole filesystem and then pg_upgrade
the clone in-place).

-- 
Thomas Munro
http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Cannot dump foreign key constraints on partitioned table
Next
From: "Tsunakawa, Takayuki"
Date:
Subject: RE: How to make partitioning scale better for larger numbers ofpartitions