bigtable; Postgres Conference China 2016 中国用户大会 Other Solutions: PL/Proxy • Created by Skype, used at big sites like MeetMe • Proxy between applications and actual data • PL = Procedural Language • Must functions for every database access – Function on shard node for actual data access – Top level proxy function determines which shard to use (or ANY or ALL) • Hash typically used for sharding the data China 2016 中国用户大会 OLTP – Write-Heavy Workload • Use custom sharding such as schema-level • PL/Proxy • Postgres-XL Strong Consistency Required • Postgres-XL Postgres Conference China 2016 中国用户大会 Geo-distributed

central server where they are combined and returned to the user. This can be implemented using the PL/Proxy tool set. It should also be noted that because PostgreSQL is open source and easily extended, a number having to decrypt the SSL stream. (Note that this requires a proxy that is aware of the PostgreSQL protocol handshake, not just any SSL proxy.) However, SNI makes the destination host name appear in cleartext Windows. Note When using the GNU C library for collations, the C library's version is used as a proxy for the collation version. Many Linux distributions change collation definitions only when upgrading

central server where they are combined and returned to the user. This can be implemented using the PL/Proxy tool set. It should also be noted that because PostgreSQL is open source and easily extended, a number having to decrypt the SSL stream. (Note that this requires a proxy that is aware of the PostgreSQL protocol handshake, not just any SSL proxy.) However, SNI makes the destination host name appear in cleartext Windows. Note When using the GNU C library for collations, the C library's version is used as a proxy for the collation version. Many Linux distributions change collation definitions only when upgrading

central server where they are combined and returned to the user. This can be implemented using the PL/Proxy tool set. It should also be noted that because PostgreSQL is open source and easily extended, a number having to decrypt the SSL stream. (Note that this requires a proxy that is aware of the PostgreSQL protocol handshake, not just any SSL proxy.) However, SNI makes the destination host name appear in cleartext platforms. Note When using the GNU C library for collations, the C library's version is used as a proxy for the collation version. Many Linux distributions change collation definitions only when upgrading

central server where they are combined and returned to the user. This can be implemented using the PL/Proxy tool set. It should also be noted that because PostgreSQL is open source and easily extended, a number having to decrypt the SSL stream. (Note that this requires a proxy that is aware of the PostgreSQL protocol handshake, not just any SSL proxy.) However, SNI makes the destination host name appear in cleartext platforms. Note When using the GNU C library for collations, the C library's version is used as a proxy for the collation version. Many Linux distributions change collation definitions only when upgrading

central server where they are combined and returned to the user. This can be implemented using the PL/Proxy tool set. It should also be noted that because PostgreSQL is open source and easily extended, a number having to decrypt the SSL stream. (Note that this requires a proxy that is aware of the PostgreSQL protocol handshake, not just any SSL proxy.) However, SNI makes the destination host name appear in cleartext platforms. Note When using the GNU C library for collations, the C library's version is used as a proxy for the collation version. Many Linux distributions change collation definitions only when upgrading

central server where they are combined and returned to the user. This can be implemented using the PL/Proxy tool set. It should also be noted that because PostgreSQL is open source and easily extended, a number having to decrypt the SSL stream. (Note that this requires a proxy that is aware of the PostgreSQL protocol handshake, not just any SSL proxy.) However, SNI makes the destination host name appear in cleartext platforms. Note When using the GNU C library for collations, the C library's version is used as a proxy for the collation version. Many Linux distributions change collation definitions only when upgrading

central server where they are combined and returned to the user. This can be implemented using the PL/Proxy tool set. It should also be noted that because PostgreSQL is open source and easily extended, a number SSL-aware proxies to route connections without having to decrypt the SSL stream. (Note that unless the proxy is aware of the PostgreSQL protocol handshake this would require setting sslnegotiation to direct platforms. Note When using the GNU C library for collations, the C library's version is used as a proxy for the collation version. Many Linux distributions change collation definitions only when upgrading

central server where they are combined and returned to the user. This can be implemented using the PL/Proxy tool set. It should also be noted that because PostgreSQL is open source and easily extended, a number SSL-aware proxies to route connections without having to decrypt the SSL stream. (Note that unless the proxy is aware of the PostgreSQL protocol handshake this would require setting sslnegotiation to direct platforms. Note When using the GNU C library for collations, the C library's version is used as a proxy for the collation version. Many Linux distributions change collation definitions only when upgrading

and returned to the user. Pgpool-II has this capability. Also, this can be implemented using the PL/Proxy toolset. 476 Chapter 26. Monitoring Database Activity A database administrator frequently wonders the heap row in all cases, but that is too expensive. Instead, we use a pin on an index page as a proxy to indicate that the reader might still be “in flight” from the index entry to the matching heap entry