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.

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

perf(expr): optimize overlay with high for input #10699

Closed
st1page opened this issue Jul 3, 2023 · 0 comments · Fixed by #13268
Closed

perf(expr): optimize overlay with high for input #10699

st1page opened this issue Jul 3, 2023 · 0 comments · Fixed by #13268
Assignees
Labels
help wanted Issues that need help from contributors priority/low
Milestone

Comments

@st1page
Copy link
Contributor

st1page commented Jul 3, 2023

dev=> \timing on
Timing is on.
dev=> SELECT overlay('123' placing '12345' from 1123456 for 1123456); 
 ?column? 
----------
 12312345
(1 row)

Time: 47.893 ms
dev=> SELECT overlay('123' placing '12345' from 1123456789 for 1123456789); 
 ?column? 
----------
 12312345
(1 row)

Time: 10451.279 ms (00:10.451)
dev=> SELECT overlay('123' placing '12345' from 1123456789 for 11234); 
 ?column? 
----------
 12312345
(1 row)

Time: 10423.252 ms (00:10.423)
dev=> SELECT overlay('123' placing '12345' from 11234 for 1123456789); 
 ?column? 
----------
 12312345
(1 row)

Time: 4.833 ms
@github-actions github-actions bot added this to the release-0.20 milestone Jul 3, 2023
@st1page st1page changed the title perf: optimize overlay with high for input perf(expr): optimize overlay with high for input Jul 3, 2023
@TennyZhuang TennyZhuang added the help wanted Issues that need help from contributors label Jul 3, 2023
@st1page st1page modified the milestones: release-1.0, release-1.1 Jul 12, 2023
@wangrunji0408 wangrunji0408 self-assigned this Nov 6, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
help wanted Issues that need help from contributors priority/low
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants