3 ms·
Maybe I don’t understand what you’re trying to do, but you can directly control how frequently commits occur. BEGIN INSERT … —- batch of N size COM
by sgarland 1y ago
Maybe I don’t understand what you’re trying to do, but you can directly control how frequently commits occur.
BEGIN
INSERT … —- batch of N size
COMMIT AND CHAIN
INSERT …
- PaulDavisThe1st 1y agoChance of Postgres commit mapping 1:1 onto posix fsync or equivalent: slim.
- anarazel 1y agoWithout parallelism, each commit will be at least one fdatasync (or fsync, O_SYNC/O_DSYNC write, depending on configuration). With parallelism, concurrent transaction might be flushed together, reducing the total number of fsyncs.