数据并行加载 • 水平扩展：Share-Nothing 架构水平扩展，海量数据在线分析 • 行/列存储模型：行存储支持高并发在线分析，列存储支持全表数据高性能关联聚合 • 高可靠架构：支持分布式事务及ACID，双副本、主备切换透明，支持服务高可用 分 区 分 区 分 区 分 区 计算组 分 区 分 区 分 区 分 区 计算组 分 区 分 区 分 区 分 区 计算组 AnalyticDB 全并行执行架构，其单计算节点定位为“计算 组”，一个集群实例由多个计算组组成。 ⚫ 多种规格、满足不同场景需求 -交互式分析 -ETL数据清洗 增强的企业级特性-安全  -数据的备份&恢复  -SQL访问安全审计 增强的企业级特性-高可用  -Master HA切换  -故障自动恢复  -监控服务 云管控高可用 1. 阿里云分析型数据库产品介绍 2. AnalyticDB

Postgres-XL • Scale-out RDBMS • MPP for OLAP • OLTP write and read scalability • Custer-wide ACID properties • Can also act as distributed key-value store • Currently based on PostgreSQL 9

它使用发布/订阅模型对选择性的数据 复制相对物理复制来说是非常方便 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 特性 逻 辑 解 码 复 制 槽 位 技 术 自定义输出插件 自动导出快照 无 D B 限 制 logical 2016Postgres中国用户大会 Postgres

逻辑复制 • 误操作恢复 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会  Logminter • 利用多版本特性，尽可能恢复数据。 • 打开pg_log，查找误操作信息，进行还原。 • 利用pg_xlogdump查看wal日志信息，确定时 间点，然后恢复。 2016Postgres中国用户大会

terms and their meaning in the context of PostgreSQL and relational database systems in general. ACID Atomicity, Consistency, Isolation, and Durability. This set of proper- ties of database transactions the execution of a transaction, no partial results are visible after recovery. This is one of the ACID properties. Attribute An element with a certain name and data type found within a tuple. Autovacuum resolved by the time it commits, such a transaction is automatically rolled back. This is one of the ACID properties. Constraint A restriction on the values of data allowed within a table, or in attrib-

terms and their meaning in the context of PostgreSQL and relational database systems in general. ACID Atomicity, Consistency, Isolation, and Durability. This set of properties of database transactions the execution of a transaction, no partial results are visible after recovery. This is one of the ACID properties. Attribute An element with a certain name and data type found within a tuple. Autovacuum resolved by the time it commits, such a transaction is automatically rolled back. This is one of the ACID properties. Constraint A restriction on the values of data allowed within a table, or in attributes

terms and their meaning in the context of PostgreSQL and relational database systems in general. ACID Atomicity, Consistency, Isolation, and Durability. This set of properties of database transactions the execution of a transaction, no partial results are visible after recovery. This is one of the ACID properties. Attribute An element with a certain name and data type found within a tuple. Autovacuum resolved by the time it commits, such a transaction is automatically rolled back. This is one of the ACID properties. Constraint A restriction on the values of data allowed within a table, or in attributes

terms and their meaning in the context of PostgreSQL and relational database systems in general. ACID Atomicity, Consistency, Isolation, and Durability. This set of proper- ties of database transactions the execution of a transaction, no partial results are visible after recovery. This is one of the ACID properties. Attribute An element with a certain name and data type found within a tuple. Autovacuum resolved by the time it commits, such a transaction is automatically rolled back. This is one of the ACID properties. Constraint A restriction on the values of data allowed within a table, or in attrib-

terms and their meaning in the context of PostgreSQL and relational database systems in general. ACID Atomicity, Consistency, Isolation, and Durability. This set of proper- ties of database transactions the execution of a transaction, no partial results are visible after recovery. This is one of the ACID properties. Attribute An element with a certain name and data type found within a tuple. Autovacuum resolved by the time it commits, such a transaction is automatically rolled back. This is one of the ACID properties. Constraint A restriction on the values of data allowed within a table, or in attrib-

terms and their meaning in the context of PostgreSQL and relational database systems in general. ACID Atomicity, Consistency, Isolation, and Durability. This set of properties of database transactions the execution of a transaction, no partial results are visible after recovery. This is one of the ACID properties. Attribute An element with a certain name and data type found within a tuple. Autovacuum resolved by the time it commits, such a transaction is automatically rolled back. This is one of the ACID properties. Constraint A restriction on the values of data allowed within a table, or in attributes