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:[EMAIL PROTECTED]] > Sent: Thursday, March 18, 1999 10:44 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > 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 >
