Re: CREATE DATABASE with filesystem cloning
Thomas Munro <thomas.munro@gmail.com>
From: Thomas Munro <thomas.munro@gmail.com>
To: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2023-10-07T22:42:20Z
Lists: pgsql-hackers
One thing I forgot to mention about this experiment: when used in a backend I think this probably needs a chunk size (what size?) and a CFI(). Which is a bit annoying, because for best results we want SSIZE_MAX, but in the case that copy_file_range() falls back to raw copy, that'd do I/O work bounded only by segment size :-/ (That's not a problem that comes up in the similar patch for pg_upgrade.)
Commits
-
Introduce file_copy_method setting.
- f78ca6f3ebbb 18.0 landed