From: | Matthew <matt(at)ctlno(dot)com> |
---|---|
To: | "'hoelc(at)pd(dot)jaring(dot)my'" <hoelc(at)pd(dot)jaring(dot)my>, pgsql-admin(at)postgreSQL(dot)org, pgsql-general(at)postgreSQL(dot)org |
Subject: | RE: [GENERAL] db out of memory |
Date: | 1999-03-23 18:34:54 |
Message-ID: | A043233669F9D111B99700A0C92376CA0DD6ED@srv.ctlno.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)pd(dot)jaring(dot)my]
> Sent: Thursday, March 18, 1999 10:44 AM
> To: pgsql-admin(at)postgreSQL(dot)org; pgsql-general(at)postgreSQL(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Claverie | 1999-03-23 18:44:24 | Problem using Having in a sub-query wit the Count function. |
Previous Message | Eugenia Bulakh | 1999-03-23 16:34:44 | [GENERAL] Restore deleted records |