Re: [HACKERS] Re: memory leak???? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Re: memory leak????
Date
Msg-id 4967.948472254@sss.pgh.pa.us
Whole thread Raw
In response to Re: memory leak????  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
List pgsql-hackers
Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
> ... I don't know much about it, but I'll guess that you are
> exhausting memory just trying to *plan* the query, or that the
> bazillion intermediate results from the huge number of "or" clauses is
> chewing things up.

SET KSQO = 'ON' might help.  I've reduced cnfify's tendence to eat
memory when presented with a big OR-of-ANDs clause, but that fix isn't
in 6.5.* (it still needs more work).
        regards, tom lane


pgsql-hackers by date:

Previous
From: Vince Vielhaber
Date:
Subject: Re: [HACKERS] timezone problem?
Next
From: Don Baccus
Date:
Subject: Re: Re. [HACKERS] Some notes on optimizer cost estimates