Home > mailing lists

Out of memory error - Mailing list pgsql-performance

From	aditya desai
Subject	Out of memory error
Date	November 24, 2021 08:27:37
Msg-id	CAN0SRDGg3-wH+y7bNvJQa7cdR4wY+7AqoeHbV0urVfBCszSCqg@mail.gmail.com Whole thread Raw
Responses	Re: Out of memory error (Tom Lane <tgl@sss.pgh.pa.us>)
List	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.

From: Justin Pryzby
Date: 23 November 2021, 22:42:35
Subject: Re: performance of analytical query

From: Tom Lane
Date: 24 November 2021, 08:52:38
Subject: Re: Out of memory error