Re: CREATE DATABASE with filesystem cloning
Dan Langille <dan@langille.org>
From: "Dan Langille" <dan@langille.org>
To: "Thomas Munro" <thomas.munro@gmail.com>,
pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2023-10-17T02:35:02Z
Lists: 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
Commits
-
Introduce file_copy_method setting.
- f78ca6f3ebbb 18.0 landed