Re: SSI tuning points

Robert Haas  wrote:
> Kevin Grittner  wrote:
>> I'm certainly open to suggestions for better wording.
> How about something like this:
> 
> When the system is forced to combine multiple page-level predicate
> locks into a single relation-level predicate lock because the
> predicate lock table is short of memory, an increase in the rate of
> serialization failures may occur. You can avoid this by increasing
> max_pred_locks_per_transaction.
> 
> A sequential scan will always necessitate a table-level predicate
> lock. This can result in an increased rate of serialization failures.
> It may be helpful to encourage the use of index scans by reducing
> random_page_cost or increasing cpu_tuple_cost. Be sure to 
That does seem better.  Thanks.
-Kevin