Re: [ext] Re: Pointers towards identifying bulk import bottleneck(walwriter tuning?)

Holtgrewe, Manuel wrote:
> Switching off fsync leads to a drastic time improvement but still
> higher wall-clock time for four threads.

Don't do that unless you are ready to start from scratch with a new
"initdb" in the case of a crash.

You can do almost as good by setting "synchronous_commit = off",
and that is crash-safe.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com