2016Postgres中国用户大会 目录 • 规约的重要性 • 命名规约 • 设计规约 • 管理规约 • 稳定性与性能建议 • 云数据库使用建议 2016Postgres中国用户大会 规约的重要性 2016Postgres中国用户大会 目录 • 规约的重要性 • 命名规约 • 设计规约 • 管理规约 • 稳定性与性能建议 • 云数据库使用建议 2016Postgres中国用户大会 table is "????"; 使用有意义的对象名； 使用小写字母，下划线，数字； 2016Postgres中国用户大会 目录 • 规约的重要性 • 命名规约 • 设计规约 • 管理规约 • 稳定性与性能建议 • 云数据库使用建议 2016Postgres中国用户大会 设计规约 • 返回多行 • select * from tbl where xxx=? order 问题(备份、恢复、创建索引、索引深度），分区 2016Postgres中国用户大会 目录 • 规约的重要性 • 命名规约 • 设计规约 • 管理规约 • 稳定性与性能建议 • 云数据库使用建议 2016Postgres中国用户大会 管理规约 • begin; set local lock_timeout = '10s'; -- DDL query; end; • begin;

ODPS的架构演进工作。 ⚫ 2012年起，转至阿里巴巴大数据团队，负责Hbase/OTS业务支 撑，期间多次负责阿里大数据双11架构和稳定性工作 ⚫ 2018年，在阿里云数据库负责OLAP产品管理团队。 1. Greenplum发展史 @Alibaba 2. AnalyticDB for PostgreSQL产品介绍 3. AnalyticDB for PostgreSQL 典型场景 按需回流 数据仓库应用 在线数据仓库 数据 查询 数据集成 批量同步 1 3 4 2 云化在线数仓 ： 简化、敏捷、一栈式构筑数据仓库 • 一键实现 十分钟 集群创建部署 • 图形化实例管理及自动监控报警 实例SQL安全审计 实例实时监控 实例配置信息 • 云上多种生态工具配套： DTS数据传输 QuickBI DataV 数据集成 阿里云数据工 具服务 阿里云第三方 直接通过外表表即可存储数据到OSS下 适合于存放历史归档数据。  “冷数据”需要时直接查询无需重新进 行导入。  支持CSV，ORC, PARQUET。 Jul Nov Oct Sep 冷热数据统一管理，基于OSS云存储构筑数据湖分析（规划中） ...... 热数据：需要高性能分析计算的数据存放在本地 盘，可设为行存或列存适合不同业务的实时分析 冷数据：存储在OSS外部存储 保存价格低廉，数据在线可查询

#初次登录需要切换为postgres用户，直接登录，无 需密码 postgres=# alter user postgres with password 'passwdxxyy'; #修改管理员账号 postgres的密码 postgres=# postgres=# create user cof with password 'passwdxxyy2'; #创建一个名为cof的 #使用postgres用户登录，需要密 码，默认登录postgres库 postgres=# #提示符 => 表示普通账号，=#表示管理员账号 postgres=# #提示符=>前的postgres表示当前数据库名 # psql -h x.x.x.x #使用cof用户登录pg，连接 db_test这个库 db_test=> #提示符 => 表示普通账号，=#表示管理员账号 db_test=> #提示符=>前的db_test表示当前数据库名 用户信息保存在postgre

Conference China 2016 中国用户大会 数据库总体架构 PostgreSQL 主库 数据库中间件 备1 消息队列 对数据的写操作 PostgreSQL 动态节点管理 … 核心库 查询库 对数据库的读操作 备2 备份 归档 运维监控 数据库总体架构 应用 逻辑复制 2016Postgres中国用户大会 Postgres

(see Chapter 17). The terms SSL and TLS are often used interchangeably to mean a secure encrypted connection using a TLS protocol. SSL protocols are the precursors to TLS protocols, and the term SSL is still interchangeably with TLS in PostgreSQL. 18.9.1. Basic Setup With SSL support compiled in, the PostgreSQL server can be started with support for encrypted connec- tions using TLS protocols enabled by transfer encryption using TLS protocols are named ssl for historic reasons, even though support for the SSL protocol has been deprecated. SSL is in this context used interchangeably with TLS. ssl (boolean)

(see Chapter 17). The terms SSL and TLS are often used interchangeably to mean a secure encrypted connection using a TLS protocol. SSL protocols are the precursors to TLS protocols, and the term SSL is still interchange- ably with TLS in PostgreSQL. 18.9.1. Basic Setup With SSL support compiled in, the PostgreSQL server can be started with support for encrypted con- nections using TLS protocols enabled by encryption using TLS protocols are named ssl for historic reasons, even though sup- port for the SSL protocol has been deprecated. SSL is in this context used interchangeably with TLS. ssl (boolean)

(see Chapter 17). The terms SSL and TLS are often used interchangeably to mean a secure encrypted connection using a TLS protocol. SSL protocols are the precursors to TLS protocols, and the term SSL is still interchangeably with TLS in PostgreSQL. 19.9.1. Basic Setup With SSL support compiled in, the PostgreSQL server can be started with support for encrypted connec- tions using TLS protocols enabled by transfer encryption using TLS protocols are named ssl for historic reasons, even though support for the SSL protocol has been deprecated. SSL is in this context used interchangeably with TLS. 643 Server Configuration

(see Chapter 17). The terms SSL and TLS are often used interchangeably to mean a secure encrypted connection using a TLS protocol. SSL protocols are the precursors to TLS protocols, and the term SSL is still interchange- ably with TLS in PostgreSQL. 19.9.1. Basic Setup With SSL support compiled in, the PostgreSQL server can be started with support for encrypted con- nections using TLS protocols enabled by encryption using TLS protocols are named ssl for historic reasons, even though sup- port for the SSL protocol has been deprecated. SSL is in this context used interchangeably with TLS. ssl (boolean)

(see Chapter 17). The terms SSL and TLS are often used interchangeably to mean a secure encrypted connection using a TLS protocol. SSL protocols are the precursors to TLS protocols, and the term SSL is still interchangeably with TLS in PostgreSQL. 19.9.1. Basic Setup With SSL support compiled in, the PostgreSQL server can be started with support for encrypted connec- tions using TLS protocols enabled by transfer encryption using TLS protocols are named ssl for historic reasons, even though support for the SSL protocol has been deprecated. SSL is in this context used interchangeably with TLS. ssl (boolean)

(see Chapter 17). The terms SSL and TLS are often used interchangeably to mean a secure encrypted connection using a TLS protocol. SSL protocols are the precursors to TLS protocols, and the term SSL is still interchange- ably with TLS in PostgreSQL. 19.9.1. Basic Setup With SSL support compiled in, the PostgreSQL server can be started with support for encrypted con- nections using TLS protocols enabled by encryption using TLS protocols are named ssl for historic reasons, even though sup- port for the SSL protocol has been deprecated. SSL is in this context used interchangeably with TLS. ssl (boolean)