title: Postgres ShareRowExclusiveLock lock
body: <p>I have a loading Postgres server with a large number of update operations. In <code>Postgres.conf</code> I set the <code>deadlock_timeout=8s</code>.</p>
  <p>In the log I see the following:</p>
  <pre><code>process 3588 acquired ShareRowExclusiveLock on relation 17360 of database 16392 after 
  8000.000 ms
  </code></pre>
  <p>This seems really slow. What is your opinion on this? Is there a better value for <code>deadlock_timeout</code>? What other settings can help bring down lock times? And this line from the log says that the transaction was broken and any data was not updated?</p>