From: | "Sorin N(dot) Ciolofan" <ciolofan(at)ics(dot)forth(dot)gr> |
---|---|
To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-general(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org>, <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: ERROR: out of shared memory |
Date: | 2007-03-30 13:20:09 |
Message-ID: | 20070330131926.B9DC18E40FC@mailhost.ics.forth.gr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general pgsql-performance |
Dear Mr. Tom Lane,
From what I've read from the postgresql.conf file I've understood that
which each unit increasing of the "max_locks_per_transaction" parameter the
shared memory used is also increased.
But the shared memory looks to be already fully consumed according to the
error message, or is the error message irrelevant and improper in this
situation?
With best regards,
Sorin
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tuesday, March 27, 2007 4:59 PM
To: Sorin N. Ciolofan
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
"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
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2007-03-30 13:31:58 | Re: recovering using a continuous archive backup doesn'twork on Windows |
Previous Message | Rickard Sjöström | 2007-03-30 11:19:30 | Performance on views |
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Silvela | 2007-03-30 13:30:25 | time series query |
Previous Message | Teodor Sigaev | 2007-03-30 12:49:19 | Re: Tsearch2 crashes my backend, ouch ! |
From | Date | Subject | |
---|---|---|---|
Next Message | Matteo Beccati | 2007-03-30 13:36:26 | Re: Wrong plan sequential scan instead of an index one |
Previous Message | Dimitri | 2007-03-30 13:14:35 | Re: Shared buffers, db transactions commited, and write IO on Solaris |