From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | Sabin Coanda <s(dot)coanda(at)deuromedia(dot)ro> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: could not reattach to shared memory |
Date: | 2011-10-13 16:59:01 |
Message-ID: | CAHyXU0yt-o65ythB+_qGovFehUS-Quic=wzb5+ivyEjEDBXneQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Oct 13, 2011 at 9:35 AM, Sabin Coanda <s(dot)coanda(at)deuromedia(dot)ro> wrote:
> 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 ?
need:
postgres version
o/s and o/s version
relevant memory settings in postgres, especially shared buffers
value of SHMMAX etc
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | József Kurucz | 2011-10-13 17:15:26 | Re: plpgsql syntax error |
Previous Message | Evan Walter | 2011-10-13 15:41:32 | Trying to use binary replication - from tutorial |