and Managing Tablespaces 554 Creating a Tablespace 555 VMware Greenplum 6 Documentation VMware by Broadcom 26 Using a Tablespace to Store Database Objects 555 Viewing Existing Tablespaces 556 Dropping 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 558 Schema Search Paths 558 Setting tcp_keepalives_count 1969 tcp_keepalives_idle 1969 tcp_keepalives_interval 1969 temp_buffers 1970 temp_tablespaces 1970 TimeZone 1971 timezone_abbreviations 1971 track_activities 1971 track_activity_query_size

525 Creating and Managing Tablespaces 525 Creating a Tablespace 526 Using a Tablespace to Store Database Objects 526 Viewing Existing Tablespaces 527 Dropping Tablespaces 528 Moving the Location of tcp_keepalives_count 1928 tcp_keepalives_idle 1928 tcp_keepalives_interval 1928 temp_buffers 1929 temp_tablespaces 1929 TimeZone 1930 timezone_abbreviations 1930 track_activities 1930 track_activity_query_size custom input file (a file not created with using gpexpand prompts), the utility failed if custom tablespaces were configured in the cluster. This occurred because gpexpand could not find a tablespace file

549 Creating and Managing Tablespaces 549 Creating a Tablespace 550 Using a Tablespace to Store Database Objects 550 Viewing Existing Tablespaces 550 Dropping Tablespaces 552 Moving the Location of tcp_keepalives_count 1933 tcp_keepalives_idle 1933 tcp_keepalives_interval 1934 temp_buffers 1934 temp_tablespaces 1934 TimeZone 1935 timezone_abbreviations 1935 track_activities 1935 VMware Greenplum 6 Documentation problem where pg_dumpall, used by the VMware Greenplum upgrade utility, did not correctly dump tablespaces in VMware Greenplum version 5.x databases. 121 Resolved a problem where upgrade could fail with

Managing Tablespaces 727 Creating and Managing Tablespaces 0 Creating a Tablespace 727 Using a Tablespace to Store Database Objects 727 Viewing Existing Tablespaces 728 Dropping Tablespaces 729 Moving tcp_keepalives_count 1653 tcp_keepalives_idle 1653 tcp_keepalives_interval 1653 temp_buffers 1653 temp_tablespaces 1654 TimeZone 1654 timezone_abbreviations 1655 track_activities 1655 track_activity_query_size : Resolved an issue where not all spill files were using the GUC temp_tablespaces. Now all spill files will use temp_tablespaces if set. 11307 : Fixes Query Catalog Table errors when using targetlists

529 Creating and Managing Tablespaces 529 Creating a Tablespace 529 Using a Tablespace to Store Database Objects 530 Viewing Existing Tablespaces 530 Dropping Tablespaces 531 Moving the Location of tcp_keepalives_count 1869 tcp_keepalives_idle 1869 tcp_keepalives_interval 1869 temp_buffers 1869 temp_tablespaces 1870 TimeZone 1870 timezone_abbreviations 1870 track_activities 1871 track_activity_query_size upgrade utility, did not VMware Tanzu Greenplum 6 Documentation VMware, Inc 135 correctly dump tablespaces in VMware Greenplum version 5.x databases. 121 Resolved a problem where upgrade could fail with

447 Creating and Managing Tablespaces 448 Creating a Tablespace 448 Using a Tablespace to Store Database Objects 448 Viewing Existing Tablespaces 449 Dropping Tablespaces 450 Moving the Location of tcp_keepalives_count 1643 tcp_keepalives_idle 1643 tcp_keepalives_interval 1644 temp_buffers 1644 temp_tablespaces 1644 TimeZone 1645 timezone_abbreviations 1645 track_activities 1645 track_activity_query_size not all spill files were using the GUC temp_tablespaces. Now all spill VMware Tanzu Greenplum 6 Documentation VMware, Inc 148 files will use temp_tablespaces if set. 11307 Fixes Query Catalog Table

and Managing Tablespaces 526 Creating a Tablespace 527 Using a Tablespace to Store Database Objects 527 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 22 Viewing Existing Tablespaces 527 Dropping 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 529 Schema Search Paths 530 Setting tcp_keepalives_count 1861 tcp_keepalives_idle 1861 tcp_keepalives_interval 1861 temp_buffers 1861 temp_tablespaces 1862 TimeZone 1862 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 110 timezone_abbreviations

Managing Tablespaces 718 Creating and Managing Tablespaces 0 Creating a Tablespace 718 Using a Tablespace to Store Database Objects 718 Viewing Existing Tablespaces 719 Dropping Tablespaces 720 Moving tcp_keepalives_count 1642 tcp_keepalives_idle 1642 tcp_keepalives_interval 1643 temp_buffers 1643 temp_tablespaces 1643 TimeZone 1644 timezone_abbreviations 1644 track_activities 1645 track_activity_query_size temp_tablespaces setting when it generated temporary files during a sort operation on a large data set. Greenplum now places these temporary files in a tablespace specified in temp_tablespaces. 31617

317 Creating and Managing Tablespaces 317 Creating a Tablespace 318 Using a Tablespace to Store Database Objects 318 Viewing Existing Tablespaces 319 Dropping Tablespaces 320 Moving the Location of 1359 Multiple Identity Columns 1359 Generated Columns 1359 LIKE Clause 1359 WITH Clause 1360 Tablespaces 1360 Typed Tables 1360 PARTITION BY Clause 1360 PARTITION OF Clause 1360 Data Distribution 7 Documentation VMware by Broadcom 108 tcp_keepalives_interval 1791 temp_buffers 1791 temp_tablespaces 1791 TimeZone 1792 timezone_abbreviations 1792 track_activities 1793 track_activity_query_size

Managing Tablespaces 715 Creating a Tablespace 716 VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 36 Using a Tablespace to Store Database Objects 716 Viewing Existing Tablespaces 717 Dropping 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 719 Schema Search Paths 719 Setting tcp_keepalives_count 1666 tcp_keepalives_idle 1666 tcp_keepalives_interval 1666 temp_buffers 1666 temp_tablespaces 1667 TimeZone 1667 timezone_abbreviations 1668 track_activities 1668 track_activity_query_size