Sergei Shelukhin escribió:
> Hi. I have a query that does some batch deletes and inserts into a
> table. It runs for 2-3 minutes when the application that uses the
> database is in production with users doing stuff.
> Recently I have noticed that this query is a frequent victim of
> deadlocks.
What Pg version are you using?
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.