On Fri, Aug 22, 2014 at 6:45 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
> So process 66017 and 66014 are blocking each because they are running the > exact same queries. The interesting part is the process with the lower pid > is starting later then the none with the higher pid. > Locking is obvious. But why deadlock? There is just single row, and it shouldn't be able to deadlock on it?! > So what exactly is 'importer' and what does it do? > Some software written by some guy. Runs lots of queries, but the only problem we have is with these transactions. > Also what is this (59303)? > log_line_prefix is '%m %r %p %u %d ' so it's port number. depesz
