Inheritance .............................................................. 94 5.10.4. Partition Pruning ............................................................................... 98 5.10.5. Partitioning individual partition tables. CREATE INDEX ON measurement (logdate); 4. Ensure that the enable_partition_pruning configuration parameter is not disabled in post- gresql.conf. If it is, queries will not be optimized Partition Pruning Partition pruning is a query optimization technique that improves performance for declaratively par- titioned tables. As an example: 98 Data Definition SET enable_partition_pruning = on;

Inheritance ................................................................. 100 5.10.4. Partition Pruning ................................................................................... 105 5.10.5. Partitioning individual partition tables. CREATE INDEX ON measurement (logdate); 4. Ensure that the enable_partition_pruning configuration parameter is not disabled in post- gresql.conf. If it is, queries will not be optimized 10.4. Partition Pruning Partition pruning is a query optimization technique that improves performance for declaratively parti- tioned tables. As an example: SET enable_partition_pruning = on;

Inheritance .............................................................. 98 5.11.4. Partition Pruning ............................................................................. 103 5.11.5. Partitioning individual partition tables. CREATE INDEX ON measurement (logdate); 4. Ensure that the enable_partition_pruning configuration parameter is not disabled in post- gresql.conf. If it is, queries will not be optimized 11.4. Partition Pruning Partition pruning is a query optimization technique that improves performance for declaratively par- titioned tables. As an example: SET enable_partition_pruning = on;

Inheritance ................................................................. 104 5.11.4. Partition Pruning ................................................................................... 109 5.11.5. Partitioning individual partition tables. CREATE INDEX ON measurement (logdate); 4. Ensure that the enable_partition_pruning configuration parameter is not disabled in post- gresql.conf. If it is, queries will not be optimized 11.4. Partition Pruning Partition pruning is a query optimization technique that improves performance for declaratively parti- tioned tables. As an example: SET enable_partition_pruning = on;

Inheritance .............................................................. 97 5.11.4. Partition Pruning ............................................................................. 102 5.11.5. Partitioning individual partition tables. CREATE INDEX ON measurement (logdate); 4. Ensure that the enable_partition_pruning configuration parameter is not disabled in post- gresql.conf. If it is, queries will not be optimized 11.4. Partition Pruning Partition pruning is a query optimization technique that improves performance for declaratively par- titioned tables. As an example: SET enable_partition_pruning = on;

Inheritance ................................................................. 103 5.11.4. Partition Pruning ................................................................................... 108 5.11.5. Partitioning individual partition tables. CREATE INDEX ON measurement (logdate); 4. Ensure that the enable_partition_pruning configuration parameter is not disabled in post- gresql.conf. If it is, queries will not be optimized 11.4. Partition Pruning Partition pruning is a query optimization technique that improves performance for declaratively parti- tioned tables. As an example: SET enable_partition_pruning = on;

Inheritance ................................................................. 103 5.11.4. Partition Pruning ................................................................................... 108 5.11.5. Partitioning individual partition tables. CREATE INDEX ON measurement (logdate); 4. Ensure that the enable_partition_pruning configuration parameter is not disabled in post- gresql.conf. If it is, queries will not be optimized 11.4. Partition Pruning Partition pruning is a query optimization technique that improves performance for declaratively parti- tioned tables. As an example: SET enable_partition_pruning = on;

Inheritance .............................................................. 97 5.11.4. Partition Pruning ............................................................................. 102 5.11.5. Partitioning individual partition tables. CREATE INDEX ON measurement (logdate); 4. Ensure that the enable_partition_pruning configuration parameter is not disabled in post- gresql.conf. If it is, queries will not be optimized 11.4. Partition Pruning Partition pruning is a query optimization technique that improves performance for declaratively par- titioned tables. As an example: SET enable_partition_pruning = on;

Inheritance .............................................................. 99 5.11.4. Partition Pruning ............................................................................. 103 5.11.5. Partitioning individual partition tables. CREATE INDEX ON measurement (logdate); 4. Ensure that the enable_partition_pruning configuration parameter is not disabled in post- gresql.conf. If it is, queries will not be optimized Partition Pruning 103 Data Definition Partition pruning is a query optimization technique that improves performance for declaratively par- titioned tables. As an example: SET enable_partition_pruning = on;

Inheritance ................................................................. 105 5.11.4. Partition Pruning ................................................................................... 110 5.11.5. Partitioning individual partition tables. CREATE INDEX ON measurement (logdate); 4. Ensure that the enable_partition_pruning configuration parameter is not disabled in post- gresql.conf. If it is, queries will not be optimized 11.4. Partition Pruning Partition pruning is a query optimization technique that improves performance for declaratively parti- tioned tables. As an example: SET enable_partition_pruning = on;