does pg18 file_copy_method=clone helps?

[DeoLeung]

hi,

thanks for the great lib, i have a question.
pg18 has file_copy_method=clone which may leverage xfs for instance db copy.

i'm currently running docker pg https://github.com/dbfixtures/pytest-postgresql?tab=readme-ov-file#connecting-to-postgresql-in-docker

on my m4 pro, it's very fast as i map the pg volume to tmpfs
on my server, the memory speed is about 1/3 of my mac, the test speed decreased.

i came across pg18 and it's file_copy_method=clone
i map an xfs volume on my linux server into pg but the tests speed remain the same, does this trick work with the library?

[fizyk]

Hi,
Not at this moment, that's something pg18 introduced, right?

Found some text here: https://boringsql.com/posts/instant-database-clones/
And it being mentioned in changelog here: https://www.postgresql.org/docs/release/18.0/

Need to read a bit about it.