      tables.

</p><pre class="programlisting">
CREATE INDEX ON measurement (logdate);
</pre><p>
      </p></li><li class="listitem"><p>
        Ensure that the <a class="xref" href="runtime-config-query.html#GUC-ENABLE-PARTITION-PRUNING">enable_partition_pruning</a>
        configuration parameter is not disabled in <code class="filename">postgresql.conf</code>.
        If it is, queries will not be optimized as desired.
       </p></li></ol></div><p>
   </p><p>
    In the above example we would be creatin