Top
Enterprise Postgres 17 SP1 Knowledge DataManagement FeatureUser's Guide

3.7 Temporarily Disabling Vectorization Processing for Semantic Text Search

The vectorization process of this feature is performed periodically according to the specified schedule. For example, if you want to temporarily stop vectorization processing to reduce the impact on other work, you can disable vectorization processing using the ai.disable_vectorizer_schedule function.

rag_database=> SELECT ai.disable_vectorizer_schedule(pgx_vectorizer.get_vectorizer_id(view_name => 'sample_embeddings')); -- Specify the ID of the vectorizer you want to disable 

To enable it, run the ai.enable_vectorizer_schedule function.

rag_database=> SELECT ai.enable_vectorizer_schedule(pgx_vectorizer.get_vectorizer_id(view_name => 'sample_embeddings')); -- Specify the ID of the vectorizer you want to enable