Postgres Conference China 2016 中国用户大会 Scaling with PostgreSQL 9.6 and Postgres-XL Mason Sharp mason.sharp@gmail.com Huawei Postgres Conference China 2016 中国用户大会 whoami • Engineer at Huawei (USA Postgres-XC • Postgres-XL Postgres Conference China 2016 中国用户大会 Agenda • PostgreSQL 9.6 Scaling Features • Scaling Solutions • Use Cases • Postgres-XL Postgres Conference China 2016 中国用户大会 BTW- PGConf

rich set of functions and operators is available to perform various geometric operations such as scaling, translation, rotation, and determining intersections. They are explained in Section 9.11. 113 0),(1,1))’ - point ’(2.0,0)’ * Scaling/rotation box ’((0,0),(1,1))’ * point ’(2.0,0)’ 193 Chapter 9. Functions and Operators Operator Description Example / Scaling/rotation box ’((0,0),(2,2))’ / point described in this section are measured on an arbitrary scale. Only their relative values matter, hence scaling them all up or down by the same factor will result in no change in the planner’s choices. Traditionally

rich set of functions and operators is available to perform various geometric operations such as scaling, translation, rotation, and determining intersections. They are explained in Section 9.11. 8.8.1 point ’(2.0,0)’ - Translation box ’((0,0),(1,1))’ - point ’(2.0,0)’ * Scaling/rotation box ’((0,0),(1,1))’ * point ’(2.0,0)’ / Scaling/rotation box ’((0,0),(2,2))’ / point ’(2.0,0)’ 182 Chapter 9. Functions described in this section are measured on an arbitrary scale. Only their relative values matter, hence scaling them all up or down by the same factor will result in no change in the planner’s choices. Traditionally

rich set of functions and operators is available to perform various geometric operations such as scaling, 109 Chapter 8. Data Types translation, rotation, and determining intersections. They are explained point ’(2.0,0)’ - Translation box ’((0,0),(1,1))’ - point ’(2.0,0)’ * Scaling/rotation box ’((0,0),(1,1))’ * point ’(2.0,0)’ / Scaling/rotation box ’((0,0),(2,2))’ / point ’(2.0,0)’ # Point or box of intersection described in this section are measured on an arbitrary scale. Only their relative values matter, hence scaling them all up or down by the same factor will result in no change in the planner’s choices. Traditionally

rich set of functions and operators is available to perform various geometric operations such as scaling, 109 Chapter 8. Data Types translation, rotation, and determining intersections. They are explained point ’(2.0,0)’ - Translation box ’((0,0),(1,1))’ - point ’(2.0,0)’ * Scaling/rotation box ’((0,0),(1,1))’ * point ’(2.0,0)’ / Scaling/rotation box ’((0,0),(2,2))’ / point ’(2.0,0)’ # Point or box of intersection described in this section are measured on an arbitrary scale. Only their relative values matter, hence scaling them all up or down by the same factor will result in no change in the planner’s choices. Traditionally

rich set of functions and operators is available to perform various geometric operations such as scaling, translation, rotation, and determining intersections. They are explained in Section 9.11. 8.8.1 point ’(2.0,0)’ - Translation box ’((0,0),(1,1))’ - point ’(2.0,0)’ * Scaling/rotation box ’((0,0),(1,1))’ * point ’(2.0,0)’ / Scaling/rotation box ’((0,0),(2,2))’ / point ’(2.0,0)’ # Point or box of intersection described in this section are measured on an arbitrary scale. Only their relative val- ues matter, hence scaling them all up or down by the same factor will result in no change in the plan- ner’s choices. By default

rich set of functions and operators is available to perform various geometric operations such as scaling, translation, rotation, and determining intersections. They are explained in Section 9.11. 8.8.1 point ’(2.0,0)’ - Translation box ’((0,0),(1,1))’ - point ’(2.0,0)’ * Scaling/rotation box ’((0,0),(1,1))’ * point ’(2.0,0)’ / Scaling/rotation box ’((0,0),(2,2))’ / point ’(2.0,0)’ # Point or box of intersection described in this section are measured on an arbitrary scale. Only their relative values matter, hence scaling them all up or down by the same factor will result in no change in the planner’s choices. By default

rich set of functions and operators is available to perform various geometric operations such as scaling, translation, rotation, and determining intersections. They are explained in Section 9.11. 8.8.1 point ’(2.0,0)’ - Translation box ’((0,0),(1,1))’ - point ’(2.0,0)’ * Scaling/rotation box ’((0,0),(1,1))’ * point ’(2.0,0)’ / Scaling/rotation box ’((0,0),(2,2))’ / point ’(2.0,0)’ # Point or box of intersection described in this section are measured on an arbitrary scale. Only their relative values matter, hence scaling them all up or down by the same factor will result in no change in the planner’s choices. By default

rich set of functions and operators is available to perform various geometric operations such as scaling, translation, rotation, and determining intersections. They are explained in Section 9.11. 8.8.1 0),(1,1))’ - point ’(2.0,0)’ * Scaling/rotation box ’((0,0),(1,1))’ * point ’(2.0,0)’ 262 Chapter 9. Functions and Operators Operator Description Example / Scaling/rotation box ’((0,0),(2,2))’ / point described in this section are measured on an arbitrary scale. Only their relative val- ues matter, hence scaling them all up or down by the same factor will result in no change in the plan- ner’s choices. By default

rich set of functions and operators is available to perform various geometric operations such as scaling, translation, rotation, and determining intersections. They are explained in Section 9.10. 8.7.1 point ’(2.0,0)’ - Translation box ’((0,0),(1,1))’ - point ’(2.0,0)’ * Scaling/rotation box ’((0,0),(1,1))’ * point ’(2.0,0)’ / Scaling/rotation box ’((0,0),(2,2))’ / point ’(2.0,0)’ # Point or box of intersection