We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
Describe the issue
Currently we rewrite the select to multi-values insert. It requires multiple statements, and we use power-of-two packing to alleviate the overhead.
There is an alternative option:
insert into table(id, name, ...) select unnest(?), unnest(?), ...
Then we could bind the values as a set of arrays.
It might have the following improvements:
TODO:
select unnest(?), unnest(?)
values(...), (...), (...)
values(DEFAULT, ...)
DEFAULT
into
values
values(?+?, ?-?)
The text was updated successfully, but these errors were encountered:
This deserves some study for sure
Sorry, something went wrong.
No branches or pull requests
Describe the issue
Currently we rewrite the select to multi-values insert.
It requires multiple statements, and we use power-of-two packing to alleviate the overhead.
There is an alternative option:
Then we could bind the values as a set of arrays.
It might have the following improvements:
TODO:
select unnest(?), unnest(?)
compares withvalues(...), (...), (...)
values(DEFAULT, ...)
. It might beDEFAULT
would require adjusting the column list in theinto
clausevalues
likevalues(?+?, ?-?)
The text was updated successfully, but these errors were encountered: