RE: [GENERAL] db out of memory

I had a similar problem that I was able to solve by specifying the -B
option and having postgre use more RAM.   By default postgre uses very
little memory, something like 100-200k, I set it to use 8M and my
queries were faster and I have yet to run into a out of memory problem.
I'm running RedHat 5.2 so I edited the /etc/rc.d/init.d/postmaster
script file.  The new line now reads - su postgres -c
'/usr/bin/postmaster -i -B 1024 -S -D/var/lib/pgsql'

Matt O'Connor

> -----Original Message-----
> From:    hoelc [SMTP:hoelc@pd.jaring.my]
> Sent:    Thursday, March 18, 1999 10:44 AM
> To:    pgsql-admin@postgreSQL.org; pgsql-general@postgreSQL.org
> Subject:    [GENERAL] db out of memory
>
> Hello,
> I have a PostgreSQL database with Linux system.  I use C language to
> write the  database application interface programs, with libpq and
> ecpg.  Some of the programs work fine, but some always give " db out
> of
> memory error ".  Anyone have any idea what does this mean?
> Please advice.
> Thank you.
> Regards....... lch
>