户数据量很少，也需要使用双数据库，更新运维都比较麻 烦。 2018年PostgreSQL中国技术大会 PgSQL≈MySQL+MongoDB • 个人认为，PgSQL结合了MySQL关系型数据库事务处理能力 以及MongoDB的大数据处理能力。稳定性强，高并发，支 持JSON,扩展字段特别方便。 • 我们团队没有大量专业的DBA运维人员，业务迭代也非常 快，需求变更频繁，对数据库非常依赖，用了PgSQL之后， 感觉可以充分满足我们的需求。

PostgreSQL 未来演进 AnalyticDB for PostgreSQL 在线MPP数据仓库服务 简单易用、海量扩展、兼容部分Oracle 语法生态、既支持在线交互分析，也支持离线数据处理。 AnalyticDB for PostgreSQL （云Greenplum）低成本，快速 构筑在线企业数据仓库。 • 应用易开发、适配 支持SQL 2003，部分兼容Oracle语法， 支持PL/SQL PostgreSQL典型场景 4. AnalyticDB for PostgreSQL 未来演进 典型场景分析 数据分析场景 场景挑战 AnalyticDB for PostgreSQL 优势 ETL 批量处理 • 复杂 SQL 调优 • 海量数据关联聚合 • 支持标准SQL，OLAP窗口函数，存储过程 • 新一代Cascade框架 分布式SQL优化器，复杂查询免调优 • MPP多节点全并行计算，PB级数据秒级响应

reproducible, we will find it either way. If your application uses some other client interface, such as PHP, then please try to isolate the offending queries. We will probably not set up a web server to reproduce contain the character sequence ?>. Example: SELECT xmlpi(name php, ’echo "hello world";’); xmlpi ----------------------------- php echo "hello world";?> 207 Chapter 9. Functions and Operators 9 subdirectories in the list below. OpenJade 1.3.1-2 Download from http://sourceforge.net/project/downloading.php?groupname=openjade&filename=openjade- 1_3_1-2-bin.zip and uncompress in the subdirectory openjade-1

reproducible, we will find it either way. If your application uses some other client interface, such as PHP, then please try to isolate the offending queries. We will probably not set up a web server to reproduce con- tain the character sequence ?>. Example: SELECT xmlpi(name php, ’echo "hello world";’); xmlpi ----------------------------- php echo "hello world";?> 9.14.1.6. xmlroot xmlroot(xml, version text|no subdirectories in the list below. OpenJade 1.3.1-2 Download from http://sourceforge.net/project/downloading.php?groupname=openjade&filename=openjade- 1_3_1-2-bin.zip and uncompress in the subdirectory openjade-1

reproducible, we will find it either way. If your application uses some other client interface, such as PHP, then please try to isolate the offending queries. We will probably not set up a web server to reproduce con- tain the character sequence ?>. Example: SELECT xmlpi(name php, ’echo "hello world";’); xmlpi ----------------------------- php echo "hello world";?> 9.14.1.6. xmlroot xmlroot(xml, version text interesting references such as \set :foo ’something’ and get “soft links” or “variable variables” of Perl or PHP fame, respectively. Unfortunately (or fortunately?), there is no way to do anything useful with these

reproducible, we will find it either way. If your application uses some other client interface, such as PHP, then please try to isolate the offending queries. We will probably not set up a web server to reproduce contain the character sequence ?>. Example: SELECT xmlpi(name php, ’echo "hello world";’); xmlpi ----------------------------- php echo "hello world";?> 9.14.1.6. xmlroot xmlroot(xml, version text interesting references such as \set :foo ’something’ and get “soft links” or “variable variables” of Perl or PHP fame, respectively. Unfortunately (or fortunately?), there is no way to do anything useful with these

reproducible, we will find it either way. If your application uses some other client interface, such as PHP, then please try to isolate the offending queries. We will probably not set up a web server to reproduce contain the character sequence ?>. Example: SELECT xmlpi(name php, ’echo "hello world";’); xmlpi ----------------------------- php echo "hello world";?> 9.14.1.6. xmlroot xmlroot(xml, version text interesting references such as \set :foo ’something’ and get “soft links” or “variable variables” of Perl or PHP fame, respectively. Unfortunately (or fortunately?), there is no way to do anything useful with these

reproducible, we will find it either way. If your application uses some other client interface, such as PHP, then please try to isolate the offending queries. We will probably not set up a web server to reproduce Example: 248 Chapter 9. Functions and Operators SELECT xmlpi(name php, ’echo "hello world";’); xmlpi ----------------------------- php echo "hello world";?> 9.14.1.6. xmlroot xmlroot(xml, version text interesting references such as \set :foo ’something’ and get “soft links” or “variable variables” of Perl or PHP fame, respectively. Unfortunately (or fortunately?), there is no way to do anything useful with these

reproducible, we will find it either way. If your application uses some other client interface, such as PHP, then please try to isolate the offending queries. We will probably not set up a web server to reproduce con- tain the character sequence ?>. Example: SELECT xmlpi(name php, ’echo "hello world";’); xmlpi ----------------------------- php echo "hello world";?> 9.14.1.6. xmlroot xmlroot(xml, version text interesting references such as \set :foo ’something’ and get “soft links” or “variable variables” of Perl or PHP fame, respectively. Unfortunately (or fortunately?), there is no way to do anything useful with these

reproducible, we will find it either way. If your application uses some other client interface, such as PHP, then please try to isolate the offending queries. We will probably not set up a web server to reproduce contain the character sequence ?>. Example: SELECT xmlpi(name php, ’echo "hello world";’); xmlpi ----------------------------- php echo "hello world";?> 9.14.1.6. xmlroot xmlroot(xml, version text interesting references such as \set :foo ’something’ and get “soft links” or “variable variables” of Perl or PHP fame, respectively. Unfortunately (or fortunately?), there is no way to do anything useful with these