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

From gary.wolfe
Subject Re: [HACKERS] Re: memory leak????
Date
Msg-id 38888E33.43B9FCC9@biosourcetechnologies.com
Whole thread Raw
In response to Re: memory leak????  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
List pgsql-hackers
Tom Lane wrote:

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

> The problem can also be solved by doing SELECT UNION SELCT

for each "or" clause.  This is only a cute fix, it does not solve the
problemof multiple "or" "and" statements.

Gary



pgsql-hackers by date:

Previous
From: Don Baccus
Date:
Subject: Re: Re. [HACKERS] Some notes on optimizer cost estimates
Next
From: Bruce Momjian
Date:
Subject: Re: vacuum timings