| From: | "Dan Langille" <dan(at)langille(dot)org> |
|---|---|
| To: | "Thomas Munro" <thomas(dot)munro(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: CREATE DATABASE with filesystem cloning |
| Date: | 2023-10-17 02:35:02 |
| Message-ID: | 26c47b3e-2956-49c5-bd40-a6a7a501deed@app.fastmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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(at)langille(dot)org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David E. Wheeler | 2023-10-17 02:53:06 | Re: Patch: Improve Boolean Predicate JSON Path Docs |
| Previous Message | Tom Lane | 2023-10-17 02:11:41 | Re: Add support for AT LOCAL |