Re: [HACKERS] Re: memory leak????

From: "gary(dot)wolfe" <gary(dot)wolfe(at)biosourcetechnologies(dot)com>
To: hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Re: memory leak????
Date: 2000-01-21 16:49:55
Message-ID: 38888E33.43B9FCC9@biosourcetechnologies.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:

> Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-01-21 17:51:53 Re: vacuum timings
Previous Message Tom Lane 2000-01-21 16:30:54 Re: [HACKERS] Re: memory leak????