Re: Processing long AND/OR lists

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Processing long AND/OR lists
Дата
Msg-id 13585.1369583209@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Processing long AND/OR lists  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Processing long AND/OR lists
Re: Processing long AND/OR lists
Список pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> ***15,000***?  I'd say that someone has an application design issue.
> Fixing the stack overflow is a good thing, but that query is never going
> to return ...

Yeah, the parser's stack consumption seems like only the tip of the
iceberg here.

I find it hard to visualize a use-case for so many AND'ed conditions
anyway.  I could believe a lot of OR'd conditions, but very likely it
would be a list that could and should be converted to an IN condition.
        regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: [BUGS] COPY .... (FORMAT binary) syntax doesn't work
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: Using indexes for partial index builds