For information about the vectorizer management functions provided by pgai, please refer to the pgai documentation.
The automatic vectorization feature for semantic text search provides the following functions in addition to the vectorizer management functions provided by pgai.
Function | Return type | Description |
|---|---|---|
get_vectorizer_id(view_name pg_catalog.pg_regclass) | int | Returns the ID of the vectorization definition that corresponds to the specified embedded view. |
schedule_vectorizer(schedule_interval interval) | json | Specify the interval for the vectorization process in schedule_interval. This function returns a JSON to be specified in the scheduling argument of the create_vectorizer function. If schedule_interval is not specified, 10 minutes will be specified. |
alter_vectorizer_processing(vectorizer_id int, batch_size int, concurrency int) | void | Changes the amount of data to be converted at one time and the worker multiplicity for the vectorization definition with the id specified in vectorizer_id. |
alter_vectorizer_schedule(vectorizer_id int, schedule_interval interval) | void | Changes the interval for the vectorization process for the vectorization definition with the id specified in vectorizer_id. If schedule_interval is not specified, 5 minutes will be specified. |
run_vectorize_worker(vectorizer_id int) | int(worker pid) | Immediately starts the vectorization process for the vectorization definition with the ID specified in vectorizer_id, and starts the vectorization process in the background. Returns the PID of the started process. |
start_vectorize_scheduler(void) | void | This will start the vectorize scheduler that connects to the database where this SQL function was executed. If the vectorize scheduler is already running, an error will occur. |
