Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [GENERAL] ERROR: out of shared memory
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Sorin N. Ciolofan" <ciolofan(at)ics(dot)forth(dot)gr>
- Cc: pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
- Subject: Re: [GENERAL] ERROR: out of shared memory
- Date: Tue, 27 Mar 2007 09:59:15 -0400
"Sorin N. Ciolofan" <ciolofan(at)ics(dot)forth(dot)gr> writes: > It seems that the legacy application creates tables dynamically and the > number of the created tables depends on the size of the input of the > application. For the specific input which generated that error I've > estimated a number of created tables of about 4000. > Could be this the problem? If you have transactions that touch many of them within one transaction, then yup, you could be out of locktable space. Try increasing max_locks_per_transaction. regards, tom lane
- References:
- Re: [GENERAL] ERROR: out of shared memory
- From: Sorin N. Ciolofan
- Re: [GENERAL] ERROR: out of shared memory
- Prev by Date: Re: [GENERAL] ERROR: out of shared memory
- Next by Date: Re: Problems with precompiled pgsql on mac
- Previous by thread: Re: [GENERAL] ERROR: out of shared memory
- Next by thread: Problems with precompiled pgsql on mac
- Indexes: