PG Doc comments form <nore...@postgresql.org> writes: > In page https://www.postgresql.org/docs/current/indexes-bitmap-scans.html > написано следующее: > "Another example is that if we have separate indexes on x and y, one > possible implementation of a query like WHERE x = 5 AND y = 6 is to use each > index with the appropriate query clause and then AND together the index > results to identify the result rows".
> You mean "WHERE x = 5 OR y = 6"? No; the query says AND. Unioning the index results would be appropriate if it said OR, but that's a different topic. regards, tom lane