Re: [HACKERS] Horrible CREATE DATABASE Performance in High Sierra

Thanks for this breakdown Tom! FWIW - I'm on Postgres 9.6.5 as bundled with Postgres.app (2.0.5) running on 2013 MBP (2.7GHz i7 / 16GB / SSD) setup. It looks like this might be a priority for an upcoming release, so I might try to hold out for downstream, but thanks for the patch. It will help if

Re: [HACKERS] Horrible CREATE DATABASE Performance in High Sierra

Tom, Andres - Is there an issue tracker I could be looking at to follow along on the progress on this issue? Thanks so much! On Mon, Oct 2, 2017 at 9:06 PM, Tom Lane wrote: > Andres Freund writes: > > On 2017-10-02 19:50:51 -0400, Tom Lane wrote: > >>

[HACKERS] Horrible CREATE DATABASE Performance in High Sierra

I just recently "upgraded" to High Sierra and experiencing horrendous CREATE DATABASE performance. Creating a database from a 3G template DB used to take ~1m but post-upgrade is taking ~22m at a sustained write of around 4MB/s. Occasionally, attempting to create an empty database hangs