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

Поиск
Список
Период
Сортировка
От gary.wolfe
Тема Re: [HACKERS] Re: memory leak????
Дата
Msg-id 38888E33.43B9FCC9@biosourcetechnologies.com
обсуждение исходный текст
Ответ на Re: memory leak????  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
Список 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 по дате отправления:

Предыдущее
От: Don Baccus
Дата:
Сообщение: Re: Re. [HACKERS] Some notes on optimizer cost estimates
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: vacuum timings