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
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
