We have a table in Postgres that we are considering partitioning. We occasionally query an indexed field that is separate from one with the partition key.
My question is: Can partitioning the table make this query faster?
My instinct says it no. Instead of scanning one index we will now be scanning multiple indexes. However, another developer I work with insists that the query will be faster because instead of scanning one large index, the database will scan multiple smaller tables in parallel.