Out of memory error

From: aditya desai <admad123(at)gmail(dot)com>
To: Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Out of memory error
Date: 2021-11-24 05:27:37
Message-ID: CAN0SRDGg3-wH+y7bNvJQa7cdR4wY+7AqoeHbV0urVfBCszSCqg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,
In a trigger function I am creating a temp table . When an update on a
table is executed for say 10k rows. I get the below error.

ERROR: out of shared memory
HINT:You might need to increase max_locks_per_transaction
CONTEXT: SQL Statement "created temp table changedinfo(colName
varchar(100), oldValue varchar(4000), newValue varchar(4000)

Current value of max_locks_per_transaction is 64. Do I have to increase
this?

Regards,
Aditya.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2021-11-24 05:52:38 Re: Out of memory error
Previous Message Justin Pryzby 2021-11-23 19:42:35 Re: performance of analytical query