Postgres Pro
Downloads
Home   >   mailing lists

Re: could not reattach to shared memory - Mailing list pgsql-general

From Sabin Coanda
Subject Re: could not reattach to shared memory
Date
Msg-id j76t06$17en$1@news.hub.org
Whole thread Raw
In response to could not reattach to shared memory  (Andy Colson <andy@squeakycode.net>)
Responses Re: could not reattach to shared memory  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Tree view 
Sorry, for the unfinished text,

So, I run a long transaction with a lot of data, and after a while I got the
messages:

NOTICE: max_fsm_relations(1000) equals the number of relations checked
HINT: You have at least 1000 relations. Consider increasing the
configuration parameter "max_fsm_relations".
LOG: max_fsm_relations(1000) equals the number of relations checked
HINT: You have at least 1000 relations. Consider increasing the
configuration parameter "max_fsm_relations".
STATEMENT: VACUUM
FATAL: could not reattach to shared memory (key=324, addr=021A0000): 487

And the process stops.

Why ? What to do ?

TIA,
Sabin

pgsql-general by date:

Previous
From: Fabrízio de Royes Mello
Date:
Subject: Video of Activity on PostgreSQL GIT repository
Next
From: "Sabin Coanda"
Date:
Subject: could not reattach to shared memory