Re: Memory Errors...

On 19 Sep 2002 at 7:10, Ian Harding wrote:

> Can someone tell me what these mean?  They happen when running big ugly pgtcl functions that delete, insert and
updatelots of stuff in the database. 
> ERROR:  Memory exhausted in AllocSetContextCreate(8192)
> ERROR:  Memory exhausted in AllocSetAlloc(88)
> ERROR:  Memory exhausted in AllocSetAlloc(60)
> options         SHMMAXPGS=8192  # 1024 pages is the default

> which I thing brings my maximum amount of shared memory from about 4 MB to about 32 MB.  (256 MB is installed)  I
thenchanged the line in postgresql.conf like this: 
>
> shared_buffers = 3000        # 2*max_connections, min 16
>
> which I think says "PostgreSQL, there is about 24 MB of shared memory available to you."
>
> You would think this would be better, not worse, than the defaults.

Now you have recompiled the kernel, does postgres works same way with defaults?
Let's change one thing at a time..

HTH

Bye
 Shridhar

--
The Gordian Maxim:    If a string has one end, it has another.