Postgres Pro
Downloads
Home   >   mailing lists

Re: Help!!! FreeSpaceMap hashtalble out of memory. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Help!!! FreeSpaceMap hashtalble out of memory.
Date
Msg-id 165.1067273490@sss.pgh.pa.us
Whole thread Raw
In response to Help!!! FreeSpaceMap hashtalble out of memory.  ("Yurgis Baykshtis" <ybaykshtis@micropat.com>)
List pgsql-hackers
Tree view 
"Yurgis Baykshtis" <ybaykshtis@micropat.com> writes:
> In pgerr.log this always go together:
> WARNING:  ShmemAlloc: out of memory
> ERROR:  FreeSpaceMap hashtable out of memory

If you have a large number of tables in your database, it might be that
you need to increase max_locks_per_transaction.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Anthony W. Youngman"
Date:
Subject: Re: Dreaming About Redesigning SQL
Next
From: Tom Lane
Date:
Subject: Re: pg_ctl reports succes when start fails