Re: Assistance with an out of shared memory error

Hi Tom, This was very helpful, thanks for the tips. Gautam On Thu, Jan 13, 2022 at 3:36 PM Tom Lane wrote: > Gautam Bellary writes: > > I've got a PL/pgSQL function (regenerate_gateway_last_seen, attached) > that > > loops through all partitions of 2 tables ("Meas

Assistance with an out of shared memory error

Hi Postgres group, I'm reaching out for some help with an "ERROR: out of shared memory. HINT: You might need to increase max_locks_per_transaction" issue: I've got a PL/pgSQL function (regenerate_gateway_last_seen, attached) that loops through all partitions of 2 tables ("Measure" and "ValuelessM