Re: query against pg_locks leads to large memory alloc

On Mon, Aug 18, 2014 at 4:21 PM, Matheus de Oliveira
<matioli.matheus@gmail.com> wrote:
>
> 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

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