On Thu, 11 May 2000, Gregory Krasnow wrote:
> I know that there were some issues with many AND/OR joins in
> PostgreSQL 6.5 which caused the backend process to run out of memory.
> I am still having some similar issues in PostgreSQL 7.0. I was
> wondering if there some recommended configurations (i.e. amount of RAM
> on the machine, size of swap partition, buffers settings for backend
> process) which I could use to help with my problems. If I cannot
> create complex AND/OR queries, I cannot use PostgreSQL for my needs
> and will have to turn back to using MySQL which has no problems with
> the same queries.
Might be even more simple then that ... I've seen the problem here, and
each time its cause I ... ummm ... forgot to raise the limits for the
pgsql user :( doing a 'unlimit' before starting postmaster fixes my
problem each time ...
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org
