Patrick Clery <[EMAIL PROTECTED]> writes:
> I have a partial index that contains a predicate to check for whether the
> field deleted is false or not:
> CREATE INDEX people_essays_any_essaytype_idx
> ON people_essays (person_id)
> WHERE NOT deleted;
> The following query does NOT use the in
I have a partial index that contains a predicate to check for whether the
field deleted is false or not:
CREATE INDEX people_essays_any_essaytype_idx
ON people_essays (person_id)
WHERE NOT deleted;
The following query does NOT use the index:
EXPLAIN ANALYZE
SELECT *
FROM people_essays
W
