Bruce Momjian <[EMAIL PROTECTED]> writes:
>> stack size (kbytes) 8192
> ^^^^
> I bet this is the problem.
Nah, 8 meg stack should be fine --- that's the same configuration I run.
>> 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.
AFAIK the AND/OR issues are largely licked, but we do still have
problems with memory leakages during execution for expressions involving
pass-by-reference datatypes. There are plans on the table to fix that
for 7.1.
But, that might or might not be your problem. It's difficult to give
any advice without some details about the queries that are giving you
trouble.
regards, tom lane
