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
>