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.
- Greg
