I'm doing a bunch of data mining against a postgres database and have
run into an interesting problem with deadlocks. The problem is,
postgres is detecting them and then wacking the offending process, and
I can't figure out what's causing them. I have a ton of select queries
(but none for update), and then a single query to insert into a table.
Nothing selects from that table. So where could the deadlock be?
pg_stat_activity has a column named current_query, which would seem
useful in tracking this down, but it's not being populated.
Oh, I'm running 7.4.2.