Re: Very inefficient query plan with disjunction in WHERE clause
От
Matthew Wakeling
Тема
Re: Very inefficient query plan with disjunction in WHERE
clause
Дата
Msg-id
alpine.DEB.1.10.0906011736110.4147@aragorn.flymine.org
Ответ на
Very inefficient query plan with disjunction in WHERE clause (Koen Martens)
Список
Дерево обсуждения
Very inefficient query plan with disjunction in WHERE clause Koen Martens <pgsql@metro.cx>
Re: Very inefficient query plan with disjunction in WHERE
clause Віталій Тимчишин <tivv00@gmail.com>
Re: Very inefficient query plan with disjunction in WHERE
clause Matthew Wakeling <matthew@flymine.org>
Re: Very inefficient query plan with disjunction in WHERE
clause Matthew Wakeling <matthew@flymine.org>
On Mon, 1 Jun 2009, Koen Martens wrote: > Anyway, any hints on getting this beast perform (without rewriting the > query, that's not possible in this case due to the query being generated > by an ORM) are welcome. I'm starting to think it is impossible, and that > postgresql just doesn't work for this particular query+dataset. Yeah, being bound by the ORM can be annoying. What version of Postgres is this? Recent versions can sometimes do a bitmap index scan to satisfy an OR constraint. Matthew -- Anyone who goes to a psychiatrist ought to have his head examined.
В списке pgsql-performance по дате отправления
От: Matthew Wakeling
Дата:
