Re: Horrible CREATE DATABASE Performance in High Sierra
Andres Freund <andres@anarazel.de>
From: Andres Freund <andres@anarazel.de>
To: pgsql-hackers@postgresql.org,Peter Eisentraut
<peter.eisentraut@2ndquadrant.com>,Tom Lane <tgl@sss.pgh.pa.us>,Brent Dearth
<brent.dearth@gmail.com>
Date: 2017-11-08T15:32:12Z
Lists: pgsql-hackers
On November 8, 2017 7:31:17 AM PST, Peter Eisentraut <peter.eisentraut@2ndquadrant.com> wrote: >On 10/7/17 16:46, Tom Lane wrote: >> I wrote: >>> Current status is that I've filed a bug report with Apple and am >waiting >>> to see their response before deciding what to do next. If they fix >the >>> issue promptly then there's little need for us to do anything. > >> Accordingly I propose the attached patch. If anyone's interested in >> experimenting on other platforms, we might be able to >refine/complicate >> the FLUSH_DISTANCE selection further, but I think this is probably >good >> enough for a first cut. > >What is the status of this? Is performance on High Sierra still bad? Didn't Tom commit a workaround? Andres -- Sent from my Android device with K-9 Mail. Please excuse my brevity.
Commits
-
Increase distance between flush requests during bulk file copies.
- c3723317d08c 10.1 landed
- 643c27e36ff3 11.0 landed
- 13a8924ecf00 9.6.6 landed