object into a set of key/value pairs. select * from json_each(‘{“a”:“foo”, “b”:“bar”}’) key | value —–+——- a | “foo” b | “bar” json_each_text(json) jsonb_each_text(jsonb) setof key text, value text Expands returned values will be of type text. select * from json_each_text(‘{“a”:“foo”, “b”:“bar”}’) key | value —–+——- a | foo b | bar json_extract_path(from_json json, VARIADIC path_elems text[]) jsonb_extract_path(from_json Expands a JSON array to a set of text values. select * from json_array_elements_text(‘[“foo”, “bar”]’) value foo bar json_typeof(json) jsonb_typeof(jsonb) text Returns the type of the outermost JSON value as

object into a set of key/value pairs. select * from json_each(‘{“a”:“foo”, “b”:“bar”}’) key | value —–+ ——- a | “foo” b | “bar” json_each_text(json) jsonb_each_text(jsonb) setof key text, value text Expands returned values will be of type text. select * from json_each_text(‘{“a”:“foo”, “b”:“bar”}’) key | value —–+——- a | foo b | bar json_extract_path(from_json json, VARIADIC path_elems text[]) jsonb_extract_path(from_json Expands a JSON array to a set of text values. select * from json_array_elements_text(‘[“foo”, “bar”]’) value foo bar json_typeof(json) jsonb_typeof(jsonb) text Returns the type of the outermost JSON value as

been enhanced to collect system initialization timestamps, /var/log/dmesg content, and output from top and sar commands. The PgBouncer distributed with Greenplum Database has been updated to version 1 that included an outer ref in a subquery, such as select * from foo where foo.a = (select foo.b from bar), GPORCA always used the results of the subquery after unnesting the outer reference. This could cause networks defined within this layer: gp- virtual-external, gp-virtual-internal and gp-virtual-etl-bar, and for this reference architecture the underlying data storage uses a vSAN cluster. In a VMware

been enhanced to collect system initialization timestamps, /var/log/dmesg content, and output from top and sar commands. The PgBouncer distributed with Greenplum Database has been updated to version 1 that included an outer ref in a subquery, such as select * from foo where foo.a = (select foo.b from bar), GPORCA always used the results of the subquery after unnesting the outer reference. This could cause three networks defined within this layer: gp-virtual-external, gp-virtual-internal and gp-virtual-etl-bar, and for this reference architecture the underlying data storage uses a vSAN cluster. In a VMware

2111 Examples 2111 list 2112 set 2112 database 2112 network base-vm 2112 network gp-virtual-etl-bar 2113 network gp-virtual-external 2113 network gp-virtual-internal 2113 vm 2113 vsphere 2114 VMware been enhanced to collect system initialization timestamps, /var/log/dmesg content, and output from top and sar commands. The PgBouncer distributed with Greenplum Database has been updated to version 1 that included an outer ref in a subquery, such as select * from foo where foo.a = (select foo.b from bar), GPORCA always used the results of the subquery after unnesting the outer reference. This could cause

2068 Examples 2068 list 2069 set 2069 database 2069 network base-vm 2069 network gp-virtual-etl-bar 2070 network gp-virtual-external 2070 network gp-virtual-internal 2070 vm 2071 vsphere 2071 gpv been enhanced to collect system initialization timestamps, /var/log/dmesg content, and output from top and sar commands. The PgBouncer distributed with Greenplum Database has been updated to version 1 that included an outer ref in a subquery, such as select * from foo where foo.a = (select foo.b from bar), GPORCA always used the results of the subquery after unnesting the outer reference. This could cause

a file ansible-playbook.yml on your Ansible control node. 5. Edit the playbook variables at the top of the playbook, such as the gpadmin administrative user and password to create, and the version of be used to assess host performance: iostat allows you to monitor disk activity on segment hosts. top displays a dynamic view of operating system processes. vmstat displays memory usage statistics. You partitioned tables, automatic statistics collection is not triggered if data is inserted from the top-level parent table of a partitioned table. But automatic statistics collection is triggered if data

that included an outer ref in a subquery, such as select * from foo where foo.a = (select foo.b from bar), GPORCA always used the results of the subquery after unnesting the outer reference. This could cause a file ansible-playbook.yml on your Ansible control node. 5. Edit the playbook variables at the top of the playbook, such as the gpadmin administrative user and password to create, and the version of be used to assess host performance: iostat allows you to monitor disk activity on segment hosts. top displays a dynamic view of operating system processes. vmstat displays memory usage statistics. VMware

that included an outer ref in a subquery, such as select * from foo where foo.a = (select foo.b from bar), GPORCA always used the results of the subquery after unnesting the outer reference. This could cause a file ansible-playbook.yml on your Ansible control node. 5. Edit the playbook variables at the top of the playbook, such as the gpadmin administrative user and password to create, and the version of be used to assess host performance: iostat allows you to monitor disk activity on segment hosts. top displays a dynamic view of operating system processes. vmstat displays memory usage statistics. VMware

that included an outer ref in a subquery, such as select * from foo where foo.a = (select foo.b from bar), GPORCA always used the results of the subquery after unnesting the outer reference. This could cause a file ansible-playbook.yml on your Ansible control node. 5. Edit the playbook variables at the top of the playbook, such as the gpadmin administrative user and password to create, and the version of be used to assess host performance: iostat allows you to monitor disk activity on segment hosts. top displays a dynamic view of operating system processes. vmstat displays memory usage statistics. You