On Thu, Oct 13, 2011 at 9:35 AM, Sabin Coanda <s.coanda@xxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
