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 store • Currently No distributed consistency Postgres-XL can do all of the above It may be difficult to build a scalability solution relying on postgres_fdw, unless schema can be partitioned in such a way to avoid distributed

with octal value 033 \f form feed, as in C \n newline, as in C \r carriage return, as in C \t horizontal tab, as in C \uwxyz (where wxyz is exactly four hexadecimal digits) the UTF16 (Unicode, 16-bit) 1)’ > ^ circle ’((0,0),1)’ ?# Intersects? lseg ’((-1,0),(1,0))’ ?# box ’((-2,-2),(2,2))’ ?- Is horizontal? ?- lseg ’((-1,0),(1,0))’ ?- Are horizontally aligned? point ’(1,0)’ ?- point ’(0,0)’ ?| Is vertical radius(circle) double precision radius of circle radius(circle ’((0,0),2.0)’) width(box) double precision horizontal size of box width(box ’((0,0),(1,1))’) 175 Chapter 9. Functions and Operators Table 9-30. Geometric

with octal value 033 \f form feed, as in C \n newline, as in C \r carriage return, as in C \t horizontal tab, as in C \uwxyz (where wxyz is exactly four hexadecimal digits) the UTF16 (Unicode, 16-bit) 1)’ > ^ circle ’((0,0),1)’ ?# Intersects? lseg ’((-1,0),(1,0))’ ?# box ’((-2,-2),(2,2))’ ?- Is horizontal? ?- lseg ’((-1,0),(1,0))’ ?- Are horizontally aligned? point ’(1,0)’ ?- point ’(0,0)’ ?| Is vertical radius(circle) double precision radius of circle radius(circle ’((0,0),2.0)’) width(box) double precision horizontal size of box width(box ’((0,0),(1,1))’) Table 9-30. Geometric Type Conversion Functions Function

with octal value 033 \f form feed, as in C \n newline, as in C \r carriage return, as in C \t horizontal tab, as in C \uwxyz (where wxyz is exactly four hexadecimal digits) the UTF16 (Unicode, 16-bit) 1)’ >^ circle ’((0,0),1)’ ?# Intersects? lseg ’((-1,0),(1,0))’ ?# box ’((-2,-2),(2,2))’ ?- Is horizontal? ?- lseg ’((-1,0),(1,0))’ ?- Are horizontally aligned? point ’(1,0)’ ?- point ’(0,0)’ ?| Is vertical radius(circle) double precision radius of circle radius(circle ’((0,0),2.0)’) width(box) double precision horizontal size of box width(box ’((0,0),(1,1))’) Table 9-33. Geometric Type Conversion Functions Function

with octal value 033 \f form feed, as in C \n newline, as in C \r carriage return, as in C \t horizontal tab, as in C \uwxyz (where wxyz is exactly four hexadecimal digits) the UTF16 (Unicode, 16-bit) 1)’ >^ circle ’((0,0),1)’ ?# Intersects? lseg ’((-1,0),(1,0))’ ?# box ’((-2,-2),(2,2))’ ?- Is horizontal? ?- lseg ’((-1,0),(1,0))’ ?- Are horizontally aligned? point ’(1,0)’ ?- point ’(0,0)’ ?| Is vertical radius(circle) double precision radius of circle radius(circle ’((0,0),2.0)’) width(box) double precision horizontal size of box width(box ’((0,0),(1,1))’) Table 9-33. Geometric Type Conversion Functions Function

with octal value 033 \f form feed, as in C \n newline, as in C \r carriage return, as in C \t horizontal tab, as in C \uwxyz (where wxyz is exactly four hexadecimal digits) the character whose hexadecimal 1)’ >^ circle ’((0,0),1)’ ?# Intersects? lseg ’((-1,0),(1,0))’ ?# box ’((-2,-2),(2,2))’ ?- Is horizontal? ?- lseg ’((-1,0),(1,0))’ ?- Are horizontally aligned? point ’(1,0)’ ?- point ’(0,0)’ ?| Is vertical radius(circle) double precision radius of circle radius(circle ’((0,0),2.0)’) width(box) double precision horizontal size of box width(box ’((0,0),(1,1))’) Table 9-35. Geometric Type Conversion Functions Function

with octal value 033 \f form feed, as in C \n newline, as in C \r carriage return, as in C \t horizontal tab, as in C \uwxyz (where wxyz is exactly four hexadecimal digits) the character whose hexadecimal 1)’ >^ circle ’((0,0),1)’ ?# Intersects? lseg ’((-1,0),(1,0))’ ?# box ’((-2,-2),(2,2))’ ?- Is horizontal? ?- lseg ’((-1,0),(1,0))’ ?- Are horizontally aligned? point ’(1,0)’ ?- point ’(0,0)’ ?| Is vertical radius(circle) double precision radius of circle radius(circle ’((0,0),2.0)’) width(box) double precision horizontal size of box width(box ’((0,0),(1,1))’) 253 Chapter 9. Functions and Operators Table 9-35. Geometric

with octal value 033 \f form feed, as in C \n newline, as in C \r carriage return, as in C \t horizontal tab, as in C \uwxyz (where wxyz is exactly four hexadecimal digits) the UTF16 (Unicode, 16-bit) 1)’ > ^ circle ’((0,0),1)’ ?# Intersects? lseg ’((-1,0),(1,0))’ ?# box ’((-2,-2),(2,2))’ ?- Is horizontal? ?- lseg ’((-1,0),(1,0))’ ?- Are horizontally aligned? point ’(1,0)’ ?- point ’(0,0)’ ?| Is vertical radius(circle) double precision radius of circle radius(circle ’((0,0),2.0)’) width(box) double precision horizontal size of box width(box ’((0,0),(1,1))’) Table 9-30. Geometric Type Conversion Functions Function

with octal value 033 \f form feed, as in C \n newline, as in C \r carriage return, as in C \t horizontal tab, as in C \uwxyz (where wxyz is exactly four hexadecimal digits) the character whose hexadecimal 1)’ >^ circle ’((0,0),1)’ ?# Intersects? lseg ’((-1,0),(1,0))’ ?# box ’((-2,-2),(2,2))’ ?- Is horizontal? ?- lseg ’((-1,0),(1,0))’ ?- Are horizontally aligned? point ’(1,0)’ ?- point ’(0,0)’ ?| Is vertical radius(circle) double precision radius of circle radius(circle ’((0,0),2.0)’) width(box) double precision horizontal size of box width(box ’((0,0),(1,1))’) Table 9-33. Geometric Type Conversion Functions Function

with octal value 033 \f form feed, as in C \n newline, as in C \r carriage return, as in C \t horizontal tab, as in C \uwxyz (where wxyz is exactly four hexadecimal digits) the character whose hexadecimal 1)’ >^ circle ’((0,0),1)’ ?# Intersects? lseg ’((-1,0),(1,0))’ ?# box ’((-2,-2),(2,2))’ ?- Is horizontal? ?- lseg ’((-1,0),(1,0))’ ?- Are horizontally aligned? point ’(1,0)’ ?- point ’(0,0)’ ?| Is vertical radius(circle) double precision radius of circle radius(circle ’((0,0),2.0)’) width(box) double precision horizontal size of box width(box ’((0,0),(1,1))’) 228 Chapter 9. Functions and Operators Table 9-33. Geometric