Re: CREATE DATABASE with filesystem cloning - Mailing list pgsql-hackers

From Dan Langille
Subject Re: CREATE DATABASE with filesystem cloning
Date
Msg-id 26c47b3e-2956-49c5-bd40-a6a7a501deed@app.fastmail.com
Whole thread Raw
In response to CREATE DATABASE with filesystem cloning  (Thomas Munro <thomas.munro@gmail.com>)
List pgsql-hackers
On Sat, Oct 7, 2023, at 1:51 AM, Thomas Munro wrote:

> I tested on bleeding edge FreeBSD/ZFS, where you need to set sysctl
> vfs.zfs.bclone_enabled=1 to enable the optimisation, as it's still a
> very new feature that is still being rolled out.  The system call
> succeeds either way, but that controls whether the new database
> initially shares blocks on disk, or get new copies.  I also tested on
> a Mac.  In both cases I could clone large databases in a fraction of a
> second.

WOOT! Looking forward to this. It would greatly improve times needed
when deploying test environments.

Thank you.

-- 
  Dan Langille
  dan@langille.org



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Add support for AT LOCAL
Next
From: "David E. Wheeler"
Date:
Subject: Re: Patch: Improve Boolean Predicate JSON Path Docs