cancancan with union join #879
Unanswered
peterpengnz
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
Hi
I am using cancancan and postgresql is the database.
For some reason, postgresql query planner doesn't use indexing when deal with
left outer joinwith multipleORconditions.This leads signaficant performance issue and I found this issue has been noticed a while ago:
https://gist.github.com/coorasse/6324cbf8773260ea46195febbe45ab50
This is the gist coorasse created and that gist explains the exactly problem I am dealing with.
So I wonder whether cancancan plans to support union join or that issue is resolved already since gist was created in 2018?
Thank you
Beta Was this translation helpful? Give feedback.
All reactions