358 Removing Bloat from System Catalogs 358 Monitoring Greenplum Database Log Files 359 Monitoring Greenplum Database Log Files 0 Loading Data 360 Loading Data 0 INSERT Statement with Column Values using the gp_segment_configuration table 533 Check for failed segments by examining log files 533 To check the log files 533 Understanding Segment Recovery 533 Understanding Segment Recovery 0 Segment Query Workfile Usage Information 620 Viewing the Database Server Log Files 620 Log File Format 621 Searching the Greenplum Server Log Files 622 Using gp_toolkit 622 SQL Standard Error Codes 622 Routine

349 Removing Bloat from System Catalogs 349 Monitoring Greenplum Database Log Files 350 Monitoring Greenplum Database Log Files 0 Loading Data 351 VMware Greenplum v6.18 Documentation VMware, Inc using the gp_segment_configuration table 524 Check for failed segments by examining log files 524 To check the log files 524 Understanding Segment Recovery 524 Understanding Segment Recovery 0 Segment Query Workfile Usage Information 611 Viewing the Database Server Log Files 612 Log File Format 612 Searching the Greenplum Server Log Files 613 Using gp_toolkit 613 SQL Standard Error Codes 614 Routine

284 Removing Bloat from System Catalogs 284 Monitoring Greenplum Database Log Files 285 Monitoring Greenplum Database Log Files 0 Loading Data 286 Loading Data 0 INSERT Statement with Column Values Query Workfile Usage Information 543 Viewing the Database Server Log Files 544 Log File Format 544 Searching the Greenplum Server Log Files 545 Using gp_toolkit 545 SQL Standard Error Codes 546 Routine Optimization 557 Routine Reindexing 558 Managing Greenplum Database Log Files 558 Database Server Log Files 558 Management Utility Log Files 559 Recommended Monitoring and Maintenance Tasks 559 Recommended

Catalogs 352 VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 16 Monitoring Greenplum Database Log Files 354 Loading Data 355 INSERT Statement with Column Values 355 COPY Statement 355 External using the gp_segment_configuration table 526 Check for failed segments by examining log files 526 To check the log files 526 Understanding Segment Recovery 526 Segment Recovery Basics 527 Segment Recovery: Query Workfile Usage Information 611 Viewing the Database Server Log Files 611 Log File Format 611 Searching the Greenplum Server Log Files 613 Using gp_toolkit 613 SQL Standard Error Codes 613 Routine

Constraints 526 Dropping a Time-based Restriction 526 Auditing 526 Viewing the Database Server Log Files 527 Encrypting Data and Database Connections 530 Encrypting gpfdist Connections 531 Encrypting Partition 585 Dropping a Partition 586 Truncating a Partition 586 Exchanging a Partition 586 Splitting a Partition 587 Modifying a Subpartition Template 587 Exchanging a Leaf Child Partition with an Documentation VMware, Inc 29 Requirements 670 Description 670 Options 671 Control File Format 672 Log File Format 681 Notes 681 Examples 682 See Also 682 pg_dump 683 Synopsis 683 Description 683

Constraints 531 Dropping a Time-based Restriction 531 Auditing 531 Viewing the Database Server Log Files 532 Encrypting Data and Database Connections 535 Encrypting gpfdist Connections 536 Encrypting Partition 591 Dropping a Partition 591 Truncating a Partition 592 Exchanging a Partition 592 Splitting a Partition 593 Modifying a Subpartition Template 593 Exchanging a Leaf Child Partition with an gpload 678 Synopsis 678 Requirements 678 Description 678 Options 679 Control File Format 680 Log File Format 689 Notes 689 Examples 690 See Also 691 pg_dump 691 Synopsis 691 Description 691

Constraints 505 Dropping a Time-based Restriction 506 Auditing 506 Viewing the Database Server Log Files 507 Encrypting Data and Database Connections 510 Encrypting gpfdist Connections 511 Encrypting Partition 564 Dropping a Partition 564 Truncating a Partition 564 Exchanging a Partition 564 Splitting a Partition 565 Modifying a Subpartition Template 566 Exchanging a Leaf Child Partition with an gpload 646 Synopsis 646 Requirements 646 Description 646 Options 647 Control File Format 648 Log File Format 656 Notes 657 Examples 657 See Also 658 pg_dump 658 Synopsis 658 Description 658

502 Auditing 502 VMware Greenplum 6 Documentation VMware, Inc. 23 Viewing the Database Server Log Files 503 Encrypting Data and Database Connections 506 Encrypting gpfdist Connections 507 Encrypting Partition 562 Dropping a Partition 562 Truncating a Partition 562 Exchanging a Partition 563 Splitting a Partition 564 Modifying a Subpartition Template 564 Exchanging a Leaf Child Partition with an gpload 648 Synopsis 649 Requirements 649 Description 649 Options 650 Control File Format 651 Log File Format 660 VMware Greenplum 6 Documentation VMware, Inc. 31 Notes 660 Examples 660 See Also

Constraints 503 Dropping a Time-based Restriction 504 Auditing 504 Viewing the Database Server Log Files 505 Encrypting Data and Database Connections 508 Encrypting gpfdist Connections 508 Encrypting Partition 561 Dropping a Partition 561 Truncating a Partition 561 Exchanging a Partition 562 Splitting a Partition 562 Modifying a Subpartition Template 563 Exchanging a Leaf Child Partition with an gpload 644 Synopsis 644 Requirements 644 Description 644 Options 645 Control File Format 646 Log File Format 654 Notes 655 Examples 655 See Also 656 pg_dump 656 Synopsis 656 Description 656

Constraints 427 Dropping a Time-based Restriction 428 Auditing 428 Viewing the Database Server Log Files 428 Encrypting Data and Database Connections 431 Encrypting gpfdist Connections 432 Encrypting Partition 479 Dropping a Partition 479 Truncating a Partition 479 Exchanging a Partition 480 Splitting a Partition 480 Modifying a Subpartition Template 481 Exchanging a Leaf Child Partition with an gpload 552 Synopsis 552 Requirements 552 Description 552 Options 553 Control File Format 554 Log File Format 562 Notes 562 Examples 562 See Also 563 pg_dump 563 Synopsis 563 Description 563