requirements? Postgres Conference China 2016 中国用户大会 What are your requirements? • Is the workload for OLTP, OLAP or is it mixed? • What percentage of transactions are read-only vs. write? • If using replicas Postgres Conference China 2016 中国用户大会 Solutions – Postgres-XL • Scale-out RDBMS • MPP for OLAP • OLTP write and read scalability • Custer-wide ACID properties • Can also act as distributed key-value are simple Postgres Conference China 2016 中国用户大会 Use Cases Postgres Conference China 2016 中国用户大会 OLTP + some reporting • Offload reporting to a separate server • Use streaming replication Postgres Conference

data warehouse type workloads, it can make sense to use a larger number of partitions than with an OLTP type workload. Generally, in data warehouses, query planning time is less of a concern as the majority ODBC Open Database Connectivity31 OID Object Identifier OLAP Online Analytical Processing32 OLTP Online Transaction Processing33 ORDBMS Object-Relational Database Management System34 PAM Pluggable org/wiki/Open_Database_Connectivity 32 http://en.wikipedia.org/wiki/Olap 33 http://en.wikipedia.org/wiki/OLTP 34 http://en.wikipedia.org/wiki/ORDBMS 35 http://en.wikipedia.org/wiki/Pluggable_Authentication_Modules

data warehouse type workloads, it can make sense to use a larger number of partitions than with an OLTP type workload. Generally, in data warehouses, query planning time is less of a concern as the majority ODBC Open Database Connectivity31 OID Object Identifier OLAP Online Analytical Processing32 OLTP Online Transaction Processing33 ORDBMS Object-Relational Database Management System34 PAM Pluggable org/wiki/Open_Database_Connectivity 32 http://en.wikipedia.org/wiki/Olap 33 http://en.wikipedia.org/wiki/OLTP 34 http://en.wikipedia.org/wiki/ORDBMS 35 http://en.wikipedia.org/wiki/Pluggable_Authentication_Modules

data warehouse type workloads, it can make sense to use a larger number of partitions than with an OLTP type workload. Generally, in data warehouses, query planning time is less of a concern as 101 Data ODBC Open Database Connectivity32 OID Object Identifier OLAP Online Analytical Processing33 OLTP Online Transaction Processing34 ORDBMS Object-Relational Database Management System35 PAM Pluggable org/wiki/Open_Database_Connectivity 33 https://en.wikipedia.org/wiki/Olap 34 https://en.wikipedia.org/wiki/OLTP 35 https://en.wikipedia.org/wiki/ORDBMS 36 https://en.wikipedia.org/wiki/Pluggable_Authentication_Modules

data warehouse type workloads, it can make sense to use a larger number of partitions than with an OLTP type workload. Generally, in data warehouses, query planning time is less of a concern as the majority ODBC Open Database Connectivity33 OID Object Identifier OLAP Online Analytical Processing34 OLTP Online Transaction Processing35 ORDBMS Object-Relational Database Management System36 PAM Pluggable org/wiki/Open_Database_Connectivity 34 https://en.wikipedia.org/wiki/Olap 35 https://en.wikipedia.org/wiki/OLTP 36 https://en.wikipedia.org/wiki/ORDBMS 37 https://en.wikipedia.org/wiki/Pluggable_Authentication_Modules

data warehouse type workloads, it can make sense to use a larger number of partitions than with an OLTP type workload. Generally, in data warehouses, query planning time is less of a concern as the majority ODBC Open Database Connectivity33 OID Object Identifier OLAP Online Analytical Processing34 OLTP Online Transaction Processing35 ORDBMS Object-Relational Database Management System36 PAM Pluggable org/wiki/Open_Database_Connectivity 34 https://en.wikipedia.org/wiki/Olap 35 https://en.wikipedia.org/wiki/OLTP 36 https://en.wikipedia.org/wiki/ORDBMS 37 https://en.wikipedia.org/wiki/Pluggable_Authentication_Modules

data warehouse type workloads, it can make sense to use a larger number of partitions than with an OLTP type workload. Generally, in data warehouses, query planning time is less of a concern as the majority ODBC Open Database Connectivity32 OID Object Identifier OLAP Online Analytical Processing33 OLTP Online Transaction Processing34 ORDBMS Object-Relational Database Management System35 PAM Pluggable org/wiki/Open_Database_Connectivity 33 https://en.wikipedia.org/wiki/Olap 34 https://en.wikipedia.org/wiki/OLTP 35 https://en.wikipedia.org/wiki/ORDBMS 36 https://en.wikipedia.org/wiki/Pluggable_Authentication_Modules

data warehouse type workloads, it can make sense to use a larger number of partitions than with an OLTP type workload. Generally, in data warehouses, query planning time is less of a concern as the majority ODBC Open Database Connectivity32 OID Object Identifier OLAP Online Analytical Processing33 OLTP Online Transaction Processing34 ORDBMS Object-Relational Database Management System35 PAM Pluggable org/wiki/Open_Database_Connectivity 33 https://en.wikipedia.org/wiki/Olap 34 https://en.wikipedia.org/wiki/OLTP 35 https://en.wikipedia.org/wiki/ORDBMS 36 https://en.wikipedia.org/wiki/Pluggable_Authentication_Modules

data warehouse type workloads, it can make sense to use a larger number of partitions than with an OLTP type workload. Generally, in data warehouses, query planning time is less of a concern as the majority ODBC Open Database Connectivity32 OID Object Identifier OLAP Online Analytical Processing33 OLTP Online Transaction Processing34 ORDBMS Object-Relational Database Management System35 PAM Pluggable org/wiki/Open_Database_Connectivity 33 https://en.wikipedia.org/wiki/Olap 34 https://en.wikipedia.org/wiki/OLTP 35 https://en.wikipedia.org/wiki/ORDBMS 36 https://en.wikipedia.org/wiki/Pluggable_Authentication_Modules

data warehouse type workloads, it can make sense to use a larger number of partitions than with an OLTP type workload. Generally, in data warehouses, query planning time is less of a concern as the majority ODBC Open Database Connectivity32 OID Object Identifier OLAP Online Analytical Processing33 OLTP Online Transaction Processing34 ORDBMS Object-Relational Database Management System35 PAM Pluggable org/wiki/Open_Database_Connectivity 33 https://en.wikipedia.org/wiki/Olap 34 https://en.wikipedia.org/wiki/OLTP 35 https://en.wikipedia.org/wiki/ORDBMS 36 https://en.wikipedia.org/wiki/Pluggable_Authentication_Modules