創建列存儲引擎插件
更新時間 2025-02-05 09:36:49
最近更新時間: 2025-02-05 09:36:49
分享文章
本頁介紹天翼云TeleDB數據庫列存儲引擎的創建、查看和刪除語法。
創建列存儲引擎插件
使用列存儲表之前，需要創建extension，插件創建完成之后，可以在 pg_extension 系統表中看到新增的插件條目
teledb=# CREATE EXTENSION pax;
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 | |
pax | 10 | 11 | f | 1.0 | |
(3 rows)
teledb=# \dx
List of installed extensions
Name | Version | Schema | Description
--------------+---------+------------+------------------------------
pax | 1.0 | pg_catalog | pax access method
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
teledbx_core | 1.0 | public | core module of teledbx
(3 rows)
查看系統表列存儲引擎新增條目
創建列存儲插件引擎后，在pg_am 系統表中看到新增的表訪問方式，在 pg_namespace 系統表中看到新增的輔助表命名空間
teledb=# select oid, * from pg_am;
oid | amname | amhandler | amtype
-------+--------+--------------------------------+--------
403 | btree | bthandler | i
405 | hash | hashhandler | i
783 | gist | gisthandler | i
2742 | gin | ginhandler | i
4000 | spgist | spghandler | i
3580 | brin | brinhandler | i
2 | heap | heap_tableam_handler | t
16396 | pax | pg_ext_aux.pax_tableam_handler | t
(8 rows)
teledb=# select oid, * from pg_namespace;
oid | nspname | nspowner | nspacl
-------+--------------------+----------+-------------------------------------------
99 | pg_toast | 10 |
5500 | pg_oracle | 10 |
7094 | pg_ext_aux | 10 |
11952 | pg_temp_1 | 10 |
11953 | pg_toast_temp_1 | 10 |
11 | pg_catalog | 10 | {teledb=UC/teledb,=U/teledb}
2200 | public | 10 | {teledb=UC/teledb,=UC/teledb}
13117 | information_schema | 10 | {teledb=UC/teledb,=U/teledb}
(8 rows)
刪除列存儲引擎插件
teledb=# DROP EXTENSION pax;
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)
