or are can you utilize other projects? Postgres Conference China 2016 中国用户大会 First, Quick Performance Ideas • Put WAL logs (pg_xlog directory) on a separate storage device • Hundreds of connections Other Solutions: PL/Proxy • Created by Skype, used at big sites like MeetMe • Proxy between applications and actual data • PL = Procedural Language • Must write two stored functions for every database 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

.....................................................................................233 13. Performance Tips ......................................................................................... ...................................................................993 II. PostgreSQL Client Applications ............................................................................................. .................................................................1070 III. PostgreSQL Server Applications ...........................................................................................1073

.....................................................................................232 13. Performance Tips ......................................................................................... ...................................................................986 II. PostgreSQL Client Applications ............................................................................................. .................................................................1063 III. PostgreSQL Server Applications ...........................................................................................1066

.....................................................................................458 14. Performance Tips ......................................................................................... Crashes........................................................510 16.7.7.5. Compiling for Optimal Performance..................................................510 16.7.7.6. Using DTrace for Tracing PostgreSQL Synchronous Standbys.........................................................693 26.2.8.3. Planning for Performance...................................................................693 26.2.8.4. Planning for High

.....................................................................................432 14. Performance Tips ......................................................................................... Sometimes Crashes.................................................482 16.7.7.5. Compiling for Optimal Performance...........................................482 16.7.7.6. Using DTrace for Tracing PostgreSQL... Synchronous Standbys..................................................656 26.2.8.3. Planning for Performance............................................................657 26.2.8.4. Planning for High Availability

.....................................................................................245 13. Performance Tips ......................................................................................... ..................................................................1096 II. PostgreSQL Client Applications .............................................................................................1099 .................................................................1176 III. PostgreSQL Server Applications ...........................................................................................1179

.....................................................................................245 13. Performance Tips ......................................................................................... ..................................................................1096 II. PostgreSQL Client Applications .............................................................................................1099 .................................................................1176 III. PostgreSQL Server Applications ...........................................................................................1179

.................................................................................352 ix 14. Performance Tips ......................................................................................... ..........................................................393 15.8.7.5. Compiling for optimal performance...................................................394 15.8.7.6. Using DTrace for tracing PostgreSQL ..................................................................1430 II. PostgreSQL Client Applications .............................................................................................1433

.....................................................................................328 14. Performance Tips ......................................................................................... crashes ...................................................367 15.8.7.5. Compiling for optimal performance............................................367 15.8.7.6. Using DTrace for tracing PostgreSQL . ..................................................................1336 II. PostgreSQL Client Applications ......................................................................................1339 clusterdb

.....................................................................................368 14. Performance Tips ......................................................................................... Crashes........................................................408 15.7.7.5. Compiling for Optimal Performance..................................................408 15.7.7.6. Using DTrace for Tracing PostgreSQL ...................................................................565 25.2.6.2. Planning for Performance...................................................................566 25.2.6.3. Planning for High