On 15 Nov 2016, at 8:34pm, Jens Alfke <j...@mooseyard.com> wrote: > On Nov 15, 2016, at 10:57 AM, Simon Slavin <slav...@bigfraud.org> wrote: > >> sqlite> PRAGMA checkpoint_fullfsync; >> 1 > > I wasn’t aware of that pragma. Just tried it on my Mac (10.12.1), and its > value is 1 even if I don’t first set pragma fullfsync; i.e. it defaults to 1. > (Contradicting the docs.) > > So it appears that on macOS, SQLite does use F_FULLFSYNC when checkpointing, > but not at other times that it fsyncs.
Yet the sequence I posted was from my own Macintosh, running 10.12.[something I can't talk about]. And as you see from my post the pragma starts off as 0 but if you set it to 1 it'll stay at 1. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users