Set vector ef_search value in CREATE TABLE statement?
Hello! The mariadb vector 11.7.1-rc release has the option to specify default_m in the CREATE TABLE statement VECTOR specification by including "M=x" option but apparently no option to specify the ef_search value. Is there any intent to add this option to the CREATE TABLE statement on the roadmap - I hope this is a valid way to set the ef_search value per table? Currently I saw this comment here : https://jira.mariadb.org/browse/MDEV-35244?focusedCommentId=293664&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-293664 which I can use as a workaround to set session value of ef_search for my needs but wanted to know if I can open a Jira wishlist ticket unless this is already planned? Thanks! -- "The World is a book, and those who do not travel read only a page." - St. Augustine.
Hi, Vishal, There is no way to set it per table, because ef_search is not a property of the index, it's a property of the search. It affects how you do SELECT, but it does not affect the index or INSERT in any way. On Jan 28, Vishal Rao via discuss wrote:
Hello!
The mariadb vector 11.7.1-rc release has the option to specify default_m in the CREATE TABLE statement VECTOR specification by including "M=x" option but apparently no option to specify the ef_search value.
Is there any intent to add this option to the CREATE TABLE statement on the roadmap - I hope this is a valid way to set the ef_search value per table?
Regards, Sergei Chief Architect, MariaDB Server and security@mariadb.org
I see! So if I understand correctly I can just set the ef_search var as a session value before executing a SELECT which should suffice to take effect? Thank you! On Tue, 28 Jan 2025 at 22:29, Sergei Golubchik <serg@mariadb.org> wrote:
Hi, Vishal,
There is no way to set it per table, because ef_search is not a property of the index, it's a property of the search. It affects how you do SELECT, but it does not affect the index or INSERT in any way.
On Jan 28, Vishal Rao via discuss wrote:
Hello!
The mariadb vector 11.7.1-rc release has the option to specify default_m in the CREATE TABLE statement VECTOR specification by including "M=x" option but apparently no option to specify the ef_search value.
Is there any intent to add this option to the CREATE TABLE statement on the roadmap - I hope this is a valid way to set the ef_search value per table?
Regards, Sergei Chief Architect, MariaDB Server and security@mariadb.org
-- "The World is a book, and those who do not travel read only a page." - St. Augustine.
or SET STATEMENT ef_search=X FOR SELECT .... https://mariadb.com/kb/en/set-statement/ On Wed, 29 Jan 2025 at 04:21, Vishal Rao via discuss < discuss@lists.mariadb.org> wrote:
I see! So if I understand correctly I can just set the ef_search var as a session value before executing a SELECT which should suffice to take effect? Thank you!
On Tue, 28 Jan 2025 at 22:29, Sergei Golubchik <serg@mariadb.org> wrote:
Hi, Vishal,
There is no way to set it per table, because ef_search is not a property of the index, it's a property of the search. It affects how you do SELECT, but it does not affect the index or INSERT in any way.
On Jan 28, Vishal Rao via discuss wrote:
Hello!
The mariadb vector 11.7.1-rc release has the option to specify default_m in the CREATE TABLE statement VECTOR specification by including "M=x" option but apparently no option to specify the ef_search value.
Is there any intent to add this option to the CREATE TABLE statement on the roadmap - I hope this is a valid way to set the ef_search value per table?
Regards, Sergei Chief Architect, MariaDB Server and security@mariadb.org
-- "The World is a book, and those who do not travel read only a page." - St. Augustine. _______________________________________________ discuss mailing list -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-leave@lists.mariadb.org
Thank you for that - appreciated :-) Looks like it works for me. On Thu, 30 Jan 2025 at 03:14, Daniel Black <daniel@mariadb.org> wrote:
or SET STATEMENT ef_search=X FOR SELECT ....
https://mariadb.com/kb/en/set-statement/
On Wed, 29 Jan 2025 at 04:21, Vishal Rao via discuss <discuss@lists.mariadb.org> wrote:
I see! So if I understand correctly I can just set the ef_search var as a session value before executing a SELECT which should suffice to take effect? Thank you!
On Tue, 28 Jan 2025 at 22:29, Sergei Golubchik <serg@mariadb.org> wrote:
Hi, Vishal,
There is no way to set it per table, because ef_search is not a property of the index, it's a property of the search. It affects how you do SELECT, but it does not affect the index or INSERT in any way.
On Jan 28, Vishal Rao via discuss wrote:
Hello!
The mariadb vector 11.7.1-rc release has the option to specify default_m in the CREATE TABLE statement VECTOR specification by including "M=x" option but apparently no option to specify the ef_search value.
Is there any intent to add this option to the CREATE TABLE statement on the roadmap - I hope this is a valid way to set the ef_search value per table?
Regards, Sergei Chief Architect, MariaDB Server and security@mariadb.org
-- "The World is a book, and those who do not travel read only a page." - St. Augustine. _______________________________________________ discuss mailing list -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-leave@lists.mariadb.org
-- "The World is a book, and those who do not travel read only a page." - St. Augustine.
participants (3)
-
Daniel Black -
Sergei Golubchik -
Vishal Rao