What I would like is the planner allways hit of_idx_modifier
What does the above explain analyze query give when you have an index on just modifier_cd, or maybe on both (modifier_cd, valtype_cd)?
Your original email said it uses the index in that case, but we would need to see the numbers in the query plan in order to figure out why it is doing that.
It seems like that the "tval_char IN ('DP')" part of the restriction is very selective, while the other two restrictions are not.
From:
James Cloos Date: Subject:
Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
✖
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.