ystem does not
    understand the relationship among the partial indexes, and will
    laboriously test each one to see if it's applicable to the current
    query.
   </p><p>
    If your table is large enough that a single index really is a bad idea,
    you should look into using partitioning instead (see
    <a class="xref" href="ddl-partitioning.html" title="5.11. Table Partitioning">Section 5.11</a>).  With that mechanism, the system
    does understand that the tables and indexes are non-overlapping