On Mon, Aug 18, 2014 at 4:21 PM, Matheus de Oliveira <matioli.matheus@xxxxxxxxx> wrote: > > On Mon, Aug 18, 2014 at 6:01 PM, Dave Owens <dave@xxxxxxxxxxxxx> wrote: >> >> max_locks_per_transaction = 9000 >> max_pred_locks_per_transaction = 40000 performance of any query to pg_locks is proportional to the setting of max_locks_per_transaction. still, something is awry here. can you 'explain' that query? also, what's the answer you get when: SELECT COUNT(*) from pg_locks; ? merlin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
