"Mikheev, Vadim" <vmikheev@SECTORBASE.COM> writes:
>> "Vadim Mikheev" <vmikheev@sectorbase.com> writes:
> Anyway, deadlock in my tests are very correlated with new log file
> creation - something probably is still wrong...
>>
>> Well, if you can reproduce it easily, seems like you could
>> get in there and verify or disprove my theory about where
>> the deadlock is.
> You were right - deadlock disappeared.
Okay, good. I'll bet the correlation to new-log-file was just because
the WAL insert_lck gets held for a longer time than usual if XLogInsert
is forced to call XLogWrite and that in turn is forced to make a new
log file. Were you running with wal_files = 0? The problem would
likely not have shown up at all if logfiles were created in advance...
> BTW, I've got ~320tps with 50 clients inserting (int4, text[1-256])
> records into 50 tables (-B 16384, wal_buffers = 256) on Ultra10
> with 512Mb RAM, IDE (clients run on the same host as server).
Not bad. What were you getting before these recent changes?
regards, tom lane
