Re: improving concurrent transactin commit rate

Sam Mason <sam@samason.me.uk> writes:
> The conceptual idea is to have at most one outstanding flush for the
> log going through the filesystem at any one time.

I think this is a variant of the "group commit" or "commit delay"
stuff that's already in there (and doesn't work real well :-().
The problem is to sync multiple transactions without a lot of extra
overhead.

Realize also that if the kernel's not completely brain dead, some
of this happens already by virtue of the fact that everyone's
fsync'ing the same WAL file.
        regards, tom lane