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 update lots 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 then changed 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.