| Type: | enum |
| Default: | copy |
| Context: | user |
| Restart: | false |
| Values: | [copy, clone] |
| Since: | 18 |
Specifies the method used to copy files. Possible values are COPY (default) and CLONE (if operating support is available).
This parameter affects:
-
CREATE DATABASE ... STRATEGY=FILE_COPY -
ALTER DATABASE ... SET TABLESPACE ...
CLONE uses the copy_file_range() (Linux, FreeBSD) or copyfile (macOS) system calls, giving the kernel the opportunity to share disk blocks or push work down to lower layers on some file systems.