关于“泼辣”DB 你应该知道的几件事-极速体验

那么问题来了,如何快速体验到“泼辣”DB 呢?

三步走。

# 拉取 PolarDB 镜像
docker pull polardb/polardb_pg_local_instance
# 创建并运行容器
podman run -d --name polardb polardb/polardb_pg_local_instance
# 连接容器
podman exec -it polardb psql

接下来,查看一些基础信息。

[root@rocky9 ~]# podman exec -it polardb psql
psql (11.9)
Type "help" for help.

postgres=# SELECT version();
            version             
--------------------------------
 PostgreSQL 11.9 (POLARDB 11.9)
(1 row)

postgres=# \l
                               List of databases
     Name      |  Owner   | Encoding  | Collate | Ctype |   Access privileges   
---------------+----------+-----------+---------+-------+-----------------------
 polardb_admin | postgres | SQL_ASCII | C       | C     | =T/postgres          +
               |          |           |         |       | postgres=CTc/postgres
 postgres      | postgres | SQL_ASCII | C       | C     | 
 template0     | postgres | SQL_ASCII | C       | C     | =c/postgres          +
               |          |           |         |       | postgres=CTc/postgres
 template1     | postgres | SQL_ASCII | C       | C     | =c/postgres          +
               |          |           |         |       | postgres=CTc/postgres
(4 rows)

postgres=# select count(name) from pg_settings where name like 'polar%';
 count 
-------
   272
(1 row)

postgres=# select setting from pg_settings where name = 'polar_supported_extensions';
           setting            
------------------------------
 pg_stat_statements          +
 btree_gin                   +
 btree_gist                  +
 citext                      +
 cube                        +
 dict_int                    +
 earthdistance               +
 hstore                      +
 intagg                      +
 intarray                    +
 isn                         +
 ltree                       +
 pgcrypto                    +
 pgrowlocks                  +
 pg_prewarm                  +
 pg_trgm                     +
 sslinfo                     +
 tablefunc                   +
 unaccent                    +
 fuzzystrmatch               +
 pgstattuple                 +
 pg_buffercache              +
 "uuid-ossp"                 +
 bloom                       +
 smlar                       +
 vector                      +
 plpgsql                     +
 plperl                      +
 postgis                     +
 postgis_raster              +
 postgis_topology            +
 postgis_sfcgal              +
 fuzzystrmatch               +
 address_standardizer        +
 address_standardizer_data_us+
 postgis_tiger_geocoder      +
 polar_csn                   +
 polar_monitor               +
 polar_monitor_preload       +
 polar_px
(1 row)

这里看到了眼熟的 vector 插件,以及几个 polar 前缀的自定义插件。

上一篇:金三银四面试题(二十四):享元模式知多少?


下一篇:R语言 统计篇之T-test 检验