PostgreSQL 在线MPP数据仓库服务 简单易用、海量扩展、兼容部分Oracle 语法生态、既支持在线交互分析，也支持离线数据处理。 AnalyticDB for PostgreSQL （云Greenplum）低成本，快速 构筑在线企业数据仓库。 • 应用易开发、适配 支持SQL 2003，部分兼容Oracle语法， 支持PL/SQL 存储过程，OLAP窗口函数，事务及数据库标准隔离级别 完备功能和生态，实现应用快速迁移或适配 MPP水平扩展架构，PB级数据查询秒级响应；向量化计算，及列存储智能索引，领先传统数据库引擎性能 3x； 新一代SQL优化器，实现复杂分析语句免调优 • 支持多模分析 通过PostGIS 插件支持 地理信息数据分析；MADlib 库内置100+ 机器学习算法库，实现数据智能探索；高性 能向量检索算法，支持视频/图像检索 以图搜图 AnalyticDB for PostgreSQL 产品架构 协调节点 OSS 分布式云存储服务 定期自动备份 OSS • 数据并行加载 • 水平扩展：Share-Nothing 架构水平扩展，海量数据在线分析 • 行/列存储模型：行存储支持高并发在线分析，列存储支持全表数据高性能关联聚合 • 高可靠架构：支持分布式事务及ACID，双副本、主备切换透明，支持服务高可用 分 区 分 区 分 区 分 区 计算组 分 区 分 区 分 区 分 区 计算组 分 区 分 区 分 区

会被 消费，即在未来的调用中还会返回这些改变。 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 使用限制 目前不支持DDL的解析, 只有DML的解析 如：create，drop TEMPORARY表和UNLOGGED表不会被复制 表必须有主键或者唯一约束，否则像update或 者delete这样的操作无法被复制

pg_size_pre�y(pg_rela�on_size('table_name')); #以方便阅读的单位列 出表的大小 ★不建议使用带\反斜杠的内置命令，有些sql终端工具不支持发送带有\反斜杠 的命令 ★第7章、表 字段操作 ★第8章、表 数据操作 db_test=# \d tablexx;

Interface Definition ............................................................. 2471 62.1. Basic API Structure for Indexes ................................................................ 2471 62.2. Index Table 9.45.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); 191 Data Types The non-default GIN operator class jsonb_path_ops does not support @? and @@. An example of creating an index with this operator class is: CREATE INDEX idxginp ON api USING GIN (jdoc jsonb_path_ops); Consider the example of a table that stores JSON documents retrieved

Method Interface Definition ....................................................... 2338 62.1. Basic API Structure for Indexes .......................................................... 2338 62.2. Index Access Table 9.45.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops does not support the key-exists @? and @@. An example of creating an index with this operator class is: CREATE INDEX idxginp ON api USING GIN (jdoc jsonb_path_ops); Consider the example of a table that stores JSON documents retrieved

Method Interface Definition ....................................................... 2254 61.1. Basic API Structure for Indexes .......................................................... 2254 61.2. Index Access Table 9.45.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops does not support the key-exists @? and @@. An example of creating an index with this operator class is: CREATE INDEX idxginp ON api USING GIN (jdoc jsonb_path_ops); Consider the example of a table that stores JSON documents retrieved

Method Interface Definition ....................................................... 2259 61.1. Basic API Structure for Indexes .......................................................... 2259 61.2. Index Access Table 9.45.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops does not support the key-exists @? and @@. An example of creating an index with this operator class is: CREATE INDEX idxginp ON api USING GIN (jdoc jsonb_path_ops); Consider the example of a table that stores JSON documents retrieved

Interface Definition ............................................................. 2389 61.1. Basic API Structure for Indexes ................................................................ 2389 61.2. Index example of creating an index with this operator class is: 189 Data Types CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops does not support the key-exists @? and @@. An example of creating an index with this operator class is: CREATE INDEX idxginp ON api USING GIN (jdoc jsonb_path_ops); Consider the example of a table that stores JSON documents retrieved

Interface Definition ............................................................. 2387 61.1. Basic API Structure for Indexes ................................................................ 2387 61.2. Index Table 9.45.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops does not support the key-exists @? and @@. An example of creating an index with this operator class is: CREATE INDEX idxginp ON api USING GIN (jdoc jsonb_path_ops); Consider the example of a table that stores JSON documents retrieved

.............................................672 25.3.3. Making a Base Backup Using the Low Level API .........................................673 25.3.3.1. Making a non-exclusive low level backup .. Definition ............................................................................2263 59.1. Basic API Structure for Indexes ............................................................................ Table 9-43.) An example of creating an index with this operator class is: CREATE INDEX idxgin ON api USING GIN (jdoc); The non-default GIN operator class jsonb_path_ops supports indexing the @> operator