Re: CREATE DATABASE with filesystem cloning

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: CREATE DATABASE with filesystem cloning
Date: 2023-10-07 22:42:20
Message-ID: CA+hUKGJdvvCd-XzwDjBVXhQiehCeodD0ZE8ohBHMje0KvQeuaA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andy Fan 2023-10-08 01:33:50 Re: Draft LIMIT pushdown to Append and MergeAppend patch
Previous Message Michał Kłeczek 2023-10-07 21:01:34 Re: Draft LIMIT pushdown to Append and MergeAppend patch