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.