ssi-tuning-1.patch

*** a/doc/src/sgml/mvcc.sgml
--- b/doc/src/sgml/mvcc.sgml
***************
*** 658,663 **** ERROR:  could not serialize access due to read/write dependencies among transact
--- 658,680 ----
         protections automatically provided by Serializable transactions.
        </para>
       </listitem>
+      <listitem>
+       <para>
+        If you are seeing a lot of serialization failures because multiple
+        page locks are being combined into relation locks, you might want to
+        increase <xref linkend="guc-max-pred-locks-per-transaction">.
+       </para>
+      </listitem>
+      <listitem>
+       <para>
+        If you are experiencing a lot of serialization failures due to
+        table-scan plans being used, you might want to try reducing
+        <xref linkend="guc-random-page-cost"> and/or increasing
+        <xref linkend="guc-cpu-tuple-cost">.  Be sure to weigh any decrease
+        in transaction rollbacks and restarts against any overall change in
+        query execution time.
+       </para>
+      </listitem>
      </itemizedlist>
     </para>