Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[YSQL] Push down comparison operators #2968

Closed
ndeodhar opened this issue Nov 19, 2019 · 1 comment
Closed

[YSQL] Push down comparison operators #2968

ndeodhar opened this issue Nov 19, 2019 · 1 comment
Assignees
@ndeodhar
Labels
area/ysql Yugabyte SQL (YSQL)
Milestone
v2.1

Comments

@ndeodhar
Copy link
Contributor

Push down simple comparison operators like > , >=, <, <=, !=, == etc. to docDB.
Today, for queries like select * from table where col > value, do a full scan of the table, retrieve all rows and then do the filtering in PG layer.
We should instead push down the comparison operator to docDB and have docDB do the filtering.
@ndeodhar ndeodhar added the area/ysql Yugabyte SQL (YSQL) label Nov 19, 2019
@ndeodhar ndeodhar added this to the v2.1 milestone Nov 19, 2019
@ndeodhar ndeodhar self-assigned this Nov 19, 2019
@ddorian ddorian mentioned this issue Dec 5, 2019
Closed
24 tasks
@ndeodhar
Copy link
Contributor Author

ndeodhar commented Jun 5, 2020

This has been done for range columns as part of #1223.

@ndeodhar ndeodhar closed this as completed Jun 5, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@ndeodhar ndeodhar

Labels
area/ysql Yugabyte SQL (YSQL)
Projects
None yet
Milestone
v2.1
Development

No branches or pull requests
1 participant
@ndeodhar