Tomas,
You are correct. I was assuming that each insert was issued as an implicit
transaction, without the benefit of an explicit BEGIN/COMMIT batching many of
them together, as I've seen countless times in tight loops trying to pose as a
batch insert.
Bob
On Fri, Mar 30, 2012 at 9:32 PM, Tomas Vondra wrote:
> And it's not just about fsync operations - WAL is written in sequential
> manner. By placing it on the same device as data files you're
> effectively forcing it to be written randomly, because the the database
> has to write a WAL record, see
