Database 314 VMware Greenplum 6 Documentation VMware by Broadcom 15 Snapshots 315 Transaction ID Wraparound 316 Transaction Isolation Levels 317 Read Committed Isolation Level 318 Repeatable Read Isolation Serializable Isolation Level 320 About Setting the Transaction Isolation Level 320 Removing Dead Rows from Tables 321 Example of Managing Transaction IDs 322 Simple MVCC Example 322 Managing Simultaneous Viewing Existing Tablespaces 556 Dropping Tablespaces 557 Moving the Location of Temporary or Transaction Files 557 Creating and Managing Schemas 557 The Default "Public" Schema 557 Creating a Schema

Database 300 Snapshots 301 VMware Greenplum 6 Documentation VMware, Inc. 14 Transaction ID Wraparound 302 Transaction Isolation Levels 303 Read Committed Isolation Level 304 Repeatable Read Isolation Serializable Isolation Level 306 About Setting the Transaction Isolation Level 306 Removing Dead Rows from Tables 307 Example of Managing Transaction IDs 308 Simple MVCC Example 308 Managing Simultaneous Viewing Existing Tablespaces 527 Dropping Tablespaces 528 Moving the Location of Temporary or Transaction Files 528 Creating and Managing Schemas 528 The Default "Public" Schema 528 Creating a Schema

Utilities 281 About Concurrency Control in Greenplum Database 282 Snapshots 283 Transaction ID Wraparound 284 Transaction Isolation Levels 285 Read Committed Isolation Level 286 VMware Greenplum 6 Documentation Serializable Isolation Level 288 About Setting the Transaction Isolation Level 288 Removing Dead Rows from Tables 289 Example of Managing Transaction IDs 290 Simple MVCC Example 290 Managing Simultaneous Viewing Existing Tablespaces 550 Dropping Tablespaces 552 Moving the Location of Temporary or Transaction Files 552 Creating and Managing Schemas 552 The Default “Public” Schema 552 Creating a Schema

Greenplum Database 274 Snapshots 275 Transaction ID Wraparound 276 Transaction Isolation Modes 276 Removing Dead Rows from Tables 278 Example of Managing Transaction IDs 279 Simple MVCC Example 280 Managing Viewing Existing Tablespaces 530 Dropping Tablespaces 531 Moving the Location of Temporary or Transaction Files 532 Creating and Managing Schemas 532 The Default “Public” Schema 532 Creating a Schema Documentation VMware, Inc 43 Deleting Rows 986 Truncating a Table 987 Working With Transactions 987 Transaction Isolation Levels 987 Read Uncommitted and Read Committed 987 Repeatable Read and Serializable

Greenplum Database 270 Snapshots 271 Transaction ID Wraparound 272 Transaction Isolation Modes 273 Removing Dead Rows from Tables 274 Example of Managing Transaction IDs 275 Simple MVCC Example 276 Managing Viewing Existing Tablespaces 527 Dropping Tablespaces 528 Moving the Location of Temporary or Transaction Files 529 Creating and Managing Schemas 529 The Default "Public" Schema 529 Creating a Schema Documentation VMware, Inc. 43 Deleting Rows 982 Truncating a Table 982 Working With Transactions 982 Transaction Isolation Levels 983 Read Uncommitted and Read Committed 983 Repeatable Read and Serializable

Utilities 164 About Concurrency Control in Greenplum Database 165 Snapshots 166 Transaction ID Wraparound 167 Transaction Isolation Levels 168 Read Committed Isolation Level 169 Repeatable Read Isolation Serializable Isolation Level 171 About Setting the Transaction Isolation Level 171 Removing Dead Rows from Tables 172 Example of Managing Transaction IDs 173 Simple MVCC Example 173 Managing Simultaneous Viewing Existing Tablespaces 319 Dropping Tablespaces 320 Moving the Location of Temporary or Transaction Files 320 Creating and Managing Schemas 320 The Default “Public” Schema 321 Creating a Schema

Greenplum Database 245 Snapshots 246 Transaction ID Wraparound 246 Transaction Isolation Modes 247 Removing Dead Rows from Tables 248 Example of Managing Transaction IDs 249 Simple MVCC Example 250 Managing Viewing Existing Tablespaces 449 Dropping Tablespaces 450 Moving the Location of Temporary or Transaction Files 450 Creating and Managing Schemas 450 The Default “Public” Schema 450 Creating a Schema Updating Existing Rows 857 Deleting Rows 858 Truncating a Table 858 Working With Transactions 858 Transaction Isolation Levels 858 Read Uncommitted and Read Committed 859 Repeatable Read and Serializable

630 Routine System Maintenance Tasks 0 Routine Vacuum and Analyze 630 Transaction ID Management 631 Recovering from a Transaction ID Limit Error 632 System Catalog Maintenance 632 Regular System Catalog Viewing Existing Tablespaces 728 Dropping Tablespaces 729 Moving the Location of Temporary or Transaction Files 729 Creating and Managing Schemas 729 Creating and Managing Schemas 0 The Default "Public" Updating Existing Rows 996 Deleting Rows 996 Truncating a Table 997 Working With Transactions 997 Transaction Isolation Levels 997 Read Uncommitted and Read Committed 997 Repeatable Read and Serializable

621 Routine System Maintenance Tasks 0 Routine Vacuum and Analyze 622 Transaction ID Management 622 Recovering from a Transaction ID Limit Error 623 System Catalog Maintenance 623 Regular System Catalog Viewing Existing Tablespaces 719 Dropping Tablespaces 720 Moving the Location of Temporary or Transaction Files 720 Creating and Managing Schemas 720 Creating and Managing Schemas 0 The Default "Public" Updating Existing Rows 987 Deleting Rows 987 Truncating a Table 988 Working With Transactions 988 Transaction Isolation Levels 988 Read Uncommitted and Read Committed 988 Repeatable Read and Serializable

Routine System Maintenance Tasks 621 Routine Vacuum and Analyze 622 Transaction ID Management 622 Recovering from a Transaction ID Limit Error 623 System Catalog Maintenance 623 Regular System Catalog Viewing Existing Tablespaces 717 Dropping Tablespaces 718 Moving the Location of Temporary or Transaction Files 718 Creating and Managing Schemas 718 The Default “Public” Schema 719 Creating a Schema 988 Working With Transactions 988 VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 48 Transaction Isolation Levels 988 Read Uncommitted and Read Committed 989 Repeatable Read and Serializable