Settings 273 Creating the Distributed Port Groups 273 Configuring the Distributed Port Groups 274 Principles of VMware Vsphere Distributed Switch to Uplink Assignment 274 Using Four 100GbE Links 275 Enabling system_* 1946 dynamic_memory_info 1947 memory_info 1948 SQL Features, Reserved and Key Words, and Compliance 1948 VMware Tanzu Greenplum 6 Documentation VMware, Inc 124 Summary of Greenplum Features 1949 and SQL Key Words 1958 Reserved Identifiers 1958 SQL Key Words 1959 SQL 2008 Optional Feature Compliance 1974 Objects Deprecated in Greenplum 6 1980 Deprecated Relations 1981 Deprecated Columns 1981

Settings 315 Creating the Distributed Port Groups 316 Configuring the Distributed Port Groups 317 Principles of VMware vSphere Distributed Switch to Uplink Assignment 317 Using Four 100GbE Links 317 Enabling system_* 2284 dynamic_memory_info 2285 memory_info 2286 SQL Features, Reserved and Key Words, and Compliance 2286 Summary of Greenplum Features 2287 Greenplum SQL Standard Conformance 2287 Core SQL Conformance and SQL Key Words 2297 Reserved Identifiers 2297 SQL Key Words 2297 SQL 2008 Optional Feature Compliance 2314 Objects Removed in Greenplum 6 2321 Removed Relations 2322 Removed Columns 2322 Removed

Settings 305 Creating the Distributed Port Groups 305 Configuring the Distributed Port Groups 306 Principles of VMware vSphere Distributed Switch to Uplink Assignment 306 Using Four 100GbE Links 307 Enabling Inc 127 dynamic_memory_info 2212 memory_info 2213 SQL Features, Reserved and Key Words, and Compliance 2214 Summary of Greenplum Features 2214 Greenplum SQL Standard Conformance 2214 Core SQL Conformance and SQL Key Words 2225 Reserved Identifiers 2225 SQL Key Words 2225 SQL 2008 Optional Feature Compliance 2242 Objects Deprecated in Greenplum 6 2249 Deprecated Relations 2249 Deprecated Columns 2250

Settings 301 Creating the Distributed Port Groups 301 Configuring the Distributed Port Groups 302 Principles of VMware vSphere Distributed Switch to Uplink Assignment 302 Using Four 100GbE Links 302 Enabling system_* 2201 dynamic_memory_info 2202 memory_info 2203 SQL Features, Reserved and Key Words, and Compliance 2204 Summary of Greenplum Features 2204 Greenplum SQL Standard Conformance 2204 Core SQL Conformance and SQL Key Words 2214 Reserved Identifiers 2214 SQL Key Words 2215 SQL 2008 Optional Feature Compliance 2232 Objects Deprecated in Greenplum 6 2260 Deprecated Relations 2260 Deprecated Columns 2261

Configuring the Distributed Port Groups 352 VMware Greenplum 6 Documentation VMware by Broadcom 17 Principles of VMware vSphere Distributed Switch to Uplink Assignment 352 Using Four 100GbE Links 353 Enabling system_* 2333 dynamic_memory_info 2334 memory_info 2335 SQL Features, Reserved and Key Words, and Compliance 2335 Summary of Greenplum Features 2336 Greenplum SQL Standard Conformance 2336 Core SQL Conformance and SQL Key Words 2347 Reserved Identifiers 2347 SQL Key Words 2347 SQL 2008 Optional Feature Compliance 2364 Objects Removed in Greenplum 6 2392 Removed Relations 2392 Removed Columns 2393 Removed

Settings 334 Creating the Distributed Port Groups 335 Configuring the Distributed Port Groups 336 Principles of VMware vSphere Distributed Switch to Uplink Assignment 336 Using Four 100GbE Links 336 Enabling system_* 2288 dynamic_memory_info 2290 memory_info 2290 SQL Features, Reserved and Key Words, and Compliance 2291 Summary of Greenplum Features 2291 Greenplum SQL Standard Conformance 2291 Core SQL Conformance and SQL Key Words 2302 Reserved Identifiers 2302 SQL Key Words 2302 SQL 2008 Optional Feature Compliance 2319 Objects Removed in Greenplum 6 2347 Removed Relations 2347 Removed Columns 2348 Removed

Background Worker Process 0 SQL Features, Reserved and Key Words, and Compliance 1810 SQL Features, Reserved and Key Words, and Compliance 0 Summary of Greenplum Features 1811 Summary of Greenplum Features Reserved Identifiers 1821 SQL Key Words 1821 SQL 2008 Optional Feature Compliance 1837 SQL 2008 Optional Feature Compliance 0 Objects Deprecated in Greenplum 6 1859 Objects Deprecated in Greenplum the SQL standard compliance for each transaction isolation level in Greenplum Database 6.0 and PostgreSQL 9.1. Requested Transaction Isolation Level Greenplum Database 6.0 Compliance PostgreSQL 9.1

Background Worker Process 0 SQL Features, Reserved and Key Words, and Compliance 1823 SQL Features, Reserved and Key Words, and Compliance 0 Summary of Greenplum Features 1823 Summary of Greenplum Features Reserved Identifiers 1834 SQL Key Words 1834 SQL 2008 Optional Feature Compliance 1850 SQL 2008 Optional Feature Compliance 0 Objects Deprecated in Greenplum 6 1871 Objects Deprecated in Greenplum the SQL standard compliance for each transaction isolation level in Greenplum Database 6.0 and PostgreSQL 9.1. Requested Transaction Isolation Level Greenplum Database 6.0 Compliance PostgreSQL 9.1

Background Worker Process 0 SQL Features, Reserved and Key Words, and Compliance 1839 SQL Features, Reserved and Key Words, and Compliance 0 Summary of Greenplum Features 1839 Summary of Greenplum Features Key Words 1850 SQL 2008 Optional Feature Compliance 1866 VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 125 SQL 2008 Optional Feature Compliance 0 Objects Deprecated in Greenplum 6 1887 the SQL standard compliance for each transaction isolation level in Greenplum Database 6.0 and PostgreSQL 9.1. Requested Transaction Isolation Level Greenplum Database 6.0 Compliance PostgreSQL 9.1

，参与者并不知道是否提交事 务，所以必须等协调者从失败中恢复。 27 两阶段提交存在的问题 1. Uncertainty Period 2. Blocking 图片来源：Bernstein的著作Principles of Transaction Processing 28 ● 事务的实现原理和Write Ahead Log（WAL） ● 分布式事务和两阶段提交的原理 ● Greenplum两阶段提交协议的实现 分布式事务和两阶段提交的原理 ● Greenplum两阶段提交协议的实现 ● Greenplum两阶段提交协议的优化 Outline 36 一阶段提交 图片来源：Bernstein的著作Principles of Transaction Processing 37 Greenplum分布式事务的一阶段提交 DTX_PROTOCOL_COMMAND_COMMIT_ONEPHASE QD