Re: file cloning in pg_upgrade and CREATE DATABASE - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: file cloning in pg_upgrade and CREATE DATABASE
Date
Msg-id 20181001022319.GA5982@paquier.xyz
Whole thread Raw
In response to Re: file cloning in pg_upgrade and CREATE DATABASE  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
On Fri, Sep 28, 2018 at 02:19:53PM +0900, Michael Paquier wrote:
> Thanks for the rebase.  At the end I got my hands on only an APFS using
> a mac.  I ran a test with an instance holding a database with pgbench at
> scaling factor 500, which gives close to 6.5GB.  The results are nice on
> my laptop:
> - --reflink=never runs in 15s
> - --reflink=always runs in 4s
> So that's a very nice gain!

Please note that I have moved the patch to CF 2018-11, as the last
review is very recent.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Relations being opened without any lock whatever
Next
From: Michael Paquier
Date:
Subject: Re: Psql patch to show access methods info