Postgres Pro
Downloads
Home   >   mailing lists

Re: query against pg_locks leads to large memory alloc - Mailing list pgsql-performance

From Matheus de Oliveira
Subject Re: query against pg_locks leads to large memory alloc
Date
Msg-id CAJghg4+y5NcvjfJO+Ynad-5NcuHHOUOgFpUEP=fLA3WTgGAoCw@mail.gmail.com
Whole thread Raw
In response to query against pg_locks leads to large memory alloc  (Dave Owens <dave@teamunify.com>)
Responses Re: query against pg_locks leads to large memory alloc
List pgsql-performance
Tree view

On Mon, Aug 18, 2014 at 6:01 PM, Dave Owens <dave@teamunify.com> wrote:
max_locks_per_transaction = 9000
max_pred_locks_per_transaction = 40000


Do you really need such large values? What is your max_connections value?

Regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres

pgsql-performance by date:

Previous
From: Dave Owens
Date:
Subject: query against pg_locks leads to large memory alloc
Next
From: Merlin Moncure
Date:
Subject: Re: query against pg_locks leads to large memory alloc