Skip site navigation (1) Skip section navigation (2)

Re: WARNING: out of shared memory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Juan C(dot) Aragon" <juan(at)keisercomputers(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: WARNING: out of shared memory
Date: 2009-07-16 23:16:52
Message-ID: 17474.1247786212@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Juan C. Aragon" <juan(at)keisercomputers(dot)com> writes:
> 2009-07-16 16:54:05 EDT    WARNING:  out of shared memory
> 2009-07-16 16:54:05 EDT    FATAL:  out of shared memory

You might be running out of lock-table space ... does raising
max_locks_per_transaction help?  (Note you need a postmaster restart
to change that.)

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2009-07-17 00:17:59
Subject: Re: Bug 4906?
Previous:From: Kevin GrittnerDate: 2009-07-16 23:16:24
Subject: Re: Bug 4906?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group