Hi , it seems that documentation on http://hdb.docs.pivotal.io/20/reference/sql/ALTER-RESOURCE-QUEUE.html contains divergent information
according to documentation query mentioned below should change vsegment resource to 16 gigs ALTER RESOURCE QUEUE pg_default WITH (VSEGMENT_RESOURCE_QUOTA='mem:16gb'); but query returns [42P17] ERROR: not defined DDL attribute name vsegment_resource_quota after looking into incubator-hawq/src/backend/resourcemanager/resqueuemanager.c file it seems that parameter for managing vsegment resource queue is called VSEG_RESOURCE_QUOTA followed query runs fine ALTER RESOURCE QUEUE pg_default WITH (VSEG_RESOURCE_QUOTA='mem:16gb'); Dominik Choma
