Re: CREATE DATABASE with filesystem cloning

Поиск
Список
Период
Сортировка
От Dan Langille
Тема Re: CREATE DATABASE with filesystem cloning
Дата
Msg-id 26c47b3e-2956-49c5-bd40-a6a7a501deed@app.fastmail.com
обсуждение исходный текст
Ответ на CREATE DATABASE with filesystem cloning  (Thomas Munro <thomas.munro@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Add support for AT LOCAL
Следующее
От: "David E. Wheeler"
Дата:
Сообщение: Re: Patch: Improve Boolean Predicate JSON Path Docs