创建向量化执行引擎插件
使用向量化执行引擎之前,需要创建extension,插件创建完成之后,可以在 pg_extension 系统表中看到新增的插件条目
teledb=# CREATE EXTENSION vectorization;
CREATE EXTENSION
teledb=# select * from pg_extension;
extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
--------------+----------+--------------+----------------+------------+-----------+--------------
plpgsql | 10 | 11 | f | 1.0 | |
teledbx_core | 10 | 2200 | t | 1.0 | |
vectorization | 10 | 2200 | t | 1.0 | |
(3 rows)
teledb=# \dx
List of installed extensions
Name | Version | Schema | Description
--------------+---------+------------+------------------------------
vectorization| 1.0 | pg_catalog | vectorization
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
teledbx_core | 1.0 | public | core module of teledbx
(3 rows)
删除向量化执行引擎插件
teledb=# DROP EXTENSION vectorization;
DROP EXTENSION
teledb=# \dx
List of installed extensions
Name | Version | Schema | Description
--------------+---------+------------+------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
teledbx_core | 1.0 | public | core module of teledbx
(2 rows)