6, one work-around for this would be to configure a multi- node Postgres-XL “cluster” on the same server, which would utilize the other cores • PostgreSQL 9.6 adds parallel operations – Sequential scans resolution after commit time (last one wins by default) • Carefully read more about potential issues: http://bdr-project.org/docs/stable/conflicts-types.html May be best to try to avoid conflicts if possible Conference 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

....................................................................................... 557 III. Server Administration ................................................................................. 18.1. Building with Visual C++ or the Microsoft Windows SDK .............................. 601 19. Server Setup and Operation ............................................................................ ................................................................ 607 19.3. Starting the Database Server ...................................................................... 610 19.4. Managing Kernel

Safety ................................................................................... 528 III. Server Administration ................................................................................. 569 18.1. Building with Visual C++ or the Microsoft Windows SDK ........................ 569 19. Server Setup and Operation ............................................................................ ................................................................ 575 19.3. Starting the Database Server ................................................................ 577 19.4. Managing Kernel Resources

....................................................................................... 580 III. Server Administration ................................................................................. Platform-Specific Notes ............................................................................ 621 18. Server Setup and Operation ............................................................................ ................................................................ 628 18.3. Starting the Database Server ...................................................................... 631 18.4. Managing Kernel

Safety ................................................................................... 549 III. Server Administration ................................................................................. Platform-Specific Notes ....................................................................... 587 18. Server Setup and Operation ............................................................................ ................................................................ 594 18.3. Starting the Database Server ................................................................ 596 18.4. Managing Kernel Resources

....................................................................................... 471 III. Server Administration ................................................................................. 17.1. Building with Visual C++ or the Microsoft Windows SDK .............................. 505 18. Server Setup and Operation ............................................................................ ................................................................ 511 18.3. Starting the Database Server ...................................................................... 513 18.4. Managing Kernel

Safety ................................................................................... 447 III. Server Administration ................................................................................. 480 17.1. Building with Visual C++ or the Microsoft Windows SDK ........................ 480 18. Server Setup and Operation ............................................................................ ................................................................ 486 18.3. Starting the Database Server ................................................................ 488 18.4. Managing Kernel Resources

Settings Functions....................................................................302 9.26.2. Server Signaling Functions.............................................................................302 .......................................................................................414 III. Server Administration ................................................................................. ........................................................................................448 17. Server Setup and Operation ............................................................................

Configuration Settings Functions.............................................................284 9.26.2. Server Signaling Functions......................................................................284 9.26 .......................................................................................388 III. Server Administration ................................................................................. ........................................................................................422 17. Server Setup and Operation ............................................................................

Settings Functions....................................................................319 9.26.2. Server Signaling Functions.............................................................................319 .......................................................................................435 III. Server Administration ................................................................................. ........................................................................................471 17. Server Setup and Operation ............................................................................