issues • No direct node-to-node row shipping • No replicated table handling • Can be ok for simple queries- SELECT COUNT(*) FROM bigtable; Postgres Conference China 2016 中国用户大会 Other Solutions: PL/Proxy China 2016 中国用户大会 Solutions: Custom Schema-level Sharding • Popularized by Instagram – http://media.postgresql.org/sfpug/Instagram_sfpug.pdf • Use schema for shards • Create many logical shards, map be partitioned in such a way to avoid distributed joins altogether, and any multi-node federated queries are simple Postgres Conference China 2016 中国用户大会 Use Cases Postgres Conference China 2016 中国用户大会

Returning Data from Modified Rows ............................................................ 116 7. Queries ................................................................................................ ............................................................................ 135 7.4. Combining Queries (UNION, INTERSECT, EXCEPT) ..................................... 137 7.5. Sorting Rows (ORDER BY) ................................................................................. 140 7.8. WITH Queries (Common Table Expressions) .................................................. 141 8. Data Types

Returning Data from Modified Rows ....................................................... 110 7. Queries ................................................................................................ ............................................................................ 128 7.4. Combining Queries (UNION, INTERSECT, EXCEPT) ................................ 130 7.5. Sorting Rows (ORDER BY) ... ................................................................................. 132 7.8. WITH Queries (Common Table Expressions) ............................................ 133 8. Data Types ......

Returning Data from Modified Rows ............................................................ 116 7. Queries ................................................................................................ ............................................................................ 134 7.4. Combining Queries .................................................................................... 136 7.5. Sorting ................................................................................. 139 7.8. WITH Queries (Common Table Expressions) .................................................. 140 8. Data Types

Returning Data from Modified Rows ....................................................... 110 7. Queries ................................................................................................ ............................................................................ 127 7.4. Combining Queries .............................................................................. 129 7.5. Sorting Rows ................................................................................. 132 7.8. WITH Queries (Common Table Expressions) ............................................ 132 8. Data Types ......

Returning Data From Modified Rows ........................................................... 113 7. Queries ................................................................................................ ............................................................................ 131 7.4. Combining Queries .................................................................................... 133 7.5. Sorting ................................................................................. 136 7.8. WITH Queries (Common Table Expressions) .................................................. 137 8. Data Types

Returning Data from Modified Rows ............................................................ 117 7. Queries ................................................................................................ ............................................................................ 135 7.4. Combining Queries .................................................................................... 137 7.5. Sorting ................................................................................. 140 7.8. WITH Queries (Common Table Expressions) .................................................. 141 8. Data Types

Returning Data From Modified Rows ...................................................... 107 7. Queries ................................................................................................ ............................................................................ 124 7.4. Combining Queries .............................................................................. 126 7.5. Sorting Rows ................................................................................. 129 7.8. WITH Queries (Common Table Expressions) ............................................ 129 8. Data Types ......

Returning Data from Modified Rows ....................................................... 111 7. Queries ................................................................................................ ............................................................................ 128 7.4. Combining Queries .............................................................................. 130 7.5. Sorting Rows ................................................................................. 133 7.8. WITH Queries (Common Table Expressions) ............................................ 133 8. Data Types ......

Returning Data From Modified Rows ........................................................... 103 7. Queries ................................................................................................ ............................................................................ 120 7.4. Combining Queries .................................................................................... 122 7.5. Sorting ................................................................................. 124 7.8. WITH Queries (Common Table Expressions) .................................................. 125 8. Data Types