On 2014-08-18 14:36:52 -0700, Dave Owens wrote: > On Mon, Aug 18, 2014 at 2:21 PM, Matheus de Oliveira > <matioli.math...@gmail.com> wrote: > > Do you really need such large values? What is your max_connections value? > > max_connections = 450 ...we have found that we run out of shared > memory when max_pred_locks_per_transaction is less than 30k.
What was the precise error message when that happened? Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance