Postgres Pro
Downloads
Home   >   mailing lists

R: repeated out of shared memory error - not related to max_locks_per_transaction - Mailing list pgsql-admin

From Alfonso Moscato
Subject R: repeated out of shared memory error - not related to max_locks_per_transaction
Date
Msg-id 019801d4203e$a650ee90$f2f2cbb0$@merqurio.it
Whole thread Raw
In response to Re: repeated out of shared memory error - not related tomax_locks_per_transaction  (Andres Freund <andres@anarazel.de>)
List pgsql-admin
Tree view 
Hi andres,
I said crazy beecause when it starts, there are many of them every few
seconds, and the only way to stop them is to restart postgres.
All of our sessions run in read_committed mode.
Regards
Alfonso

-----Messaggio originale-----
Da: Andres Freund <andres@anarazel.de>
Inviato: venerdì 20 luglio 2018 17:14
A: Alfonso Moscato <alfonso.moscato@merqurio.it>
Cc: pgsql-admin@lists.postgresql.org
Oggetto: Re: repeated out of shared memory error - not related to
max_locks_per_transaction


Hi,

On 2018-07-20 13:14:53 +0200, Alfonso Moscato wrote:
> We are getting crazy with "out of shared memory" errors, and we can't
> figure the reason.

What makes them "crazy"?

Could you please give the exact error message and statement it ran?

Are any of your sessions running with serializable isolation?

Greetings,

Andres Freund

pgsql-admin by date:

Previous
From: Shreeyansh Dba
Date:
Subject: Re: repeated out of shared memory error - not related to max_locks_per_transaction
Next
From: "Alfonso Moscato"
Date:
Subject: R: repeated out of shared memory error - not related to max_locks_per_transaction