immediately stop with an error. This distinction was chosen as a user convenience against typos, and a safety mechanism that scripts are not accidentally acting on the wrong database. Examples: => \c mydb Three resource queues are configured for them. A portion of the segment memory is reserved as a safety margin. Resource Queue Name Active Statements Memory Limit Memory per Query ETL 3 2GB 667MB Reporting total segment memory defined by the gp_vmem_protect_limit server configuration parameter. Allowing a safety margin of 20% accommodates some operators and queries that are known to use more memory than they

Three resource queues are configured for them. A portion of the segment memory is reserved as a safety margin. Resource Queue Name Active Statements Memory Limit Memory per Query ETL 3 2GB 667MB Reporting total segment memory defined by the gp_vmem_protect_limit server configuration parameter. Allowing a safety margin of 20% accommodates some operators and queries that are known to use more memory than they result of type internal. (Note: the second, internal argument is unused, but is required for type safety reasons.) initial_condition The initial setting for the state value. This must be a string constant

Three resource queues are configured for them. A portion of the segment memory is reserved as a safety margin. Resource Queue Name Active Statements Memory Limit Memory per Query ETL 3 2GB 667MB Reporting total segment memory defined by the gp_vmem_protect_limit server configuration parameter. Allowing a safety margin of 20% accommodates some operators and queries that are known to use more memory than they result of type internal. (Note: the second, internal argument is unused, but is required for type safety reasons.) initial_condition The initial setting for the state value. This must be a string constant

Three resource queues are configured for them. A portion of the segment memory is reserved as a safety margin. Resource Queue Name Active Statements Memory Limit Memory per Query ETL 3 2GB 667MB Reporting total segment memory defined by the gp_vmem_protect_limit server configuration parameter. Allowing a safety margin of 20% accommodates some operators and queries that are known to use more memory than they result of type internal. (Note: the second, internal argument is unused, but is required for type safety reasons.) initial_condition The initial setting for the state value. This must be a string constant

immediately stop with an error. This distinction was chosen as a user convenience against typos, and a safety mechanism that scripts are not accidentally acting on the wrong database. Examples: VMware Greenplum Three resource queues are configured for them. A portion of the segment memory is reserved as a safety margin. Resource Queue Name Active Statements Memory Limit Memory per Query ETL 3 2GB 667MB Reporting total segment memory defined by the gp_vmem_protect_limit server configuration parameter. Allowing a safety margin of 20% accommodates some operators and queries that are known to use more memory than they

immediately stop with an error. This distinction was chosen as a user convenience against typos, and a safety mechanism that scripts are not accidentally acting on the wrong database. Examples: => \c mydb Three resource queues are configured for them. A portion of the segment memory is reserved as a safety margin. Resource Queue Name Active Statements Memory Limit Memory per Query ETL 3 2GB 667MB Reporting total segment memory defined by the gp_vmem_protect_limit server configuration parameter. Allowing a safety margin of 20% accommodates some operators and queries that are known to use more memory than they

immediately stop with an error. This distinction was chosen as a user convenience against typos, and a safety mechanism that scripts are not accidentally acting on the wrong database. Examples: => \c mydb Three resource queues are configured for them. A portion of the segment memory is reserved as a safety margin. Resource Queue Name Active Statements Memory Limit Memory per Query ETL 3 2GB 667MB Reporting total segment memory defined by the gp_vmem_protect_limit server configuration parameter. Allowing a safety margin of 20% accommodates some operators and queries that are known to use more memory than they

immediately stop with an error. This distinction was chosen as a user convenience against typos, and a safety mechanism that scripts are not accidentally acting on the wrong database. Examples: => \c mydb Three resource queues are configured for them. A portion of the segment memory is reserved as a safety margin. Resource Queue Name Active Statements Memory Limit Memory per Query ETL 3 2GB 667MB Reporting total segment memory defined by the gp_vmem_protect_limit server configuration parameter. Allowing a safety margin of 20% accommodates some operators and queries that are known to use more memory than they

immediately stop with an error. This distinction was chosen as a user convenience against typos, and a safety mechanism that scripts are not accidentally acting on the wrong database. Examples: => \c mydb Three resource queues are configured for them. A portion of the segment memory is reserved as a safety margin. Resource Queue Name Active Statements Memory Limit Memory per Query ETL 3 2GB 667MB Reporting total segment memory defined by the gp_vmem_protect_limit server configuration parameter. Allowing a safety margin of 20% accommodates some operators and queries that are known to use more memory than they

immediately stop with an error. This distinction was chosen as a user convenience against typos, and a safety mechanism that scripts are not accidentally acting on the wrong database. Examples: => \c mydb Three resource queues are configured for them. A portion of the segment memory is reserved as a safety margin. Resource Queue Name Active Statements Memory Limit Memory per Query ETL 3 2GB 667MB Reporting total segment memory defined by the gp_vmem_protect_limit server configuration parameter. Allowing a safety margin of 20% accommodates some operators and queries that are known to use more memory than they