Jared Rulison writes:
> Hello, we have some confusion over the planner's use of an index.
> ...
> 1. How is postgres able to use parades_city_id_description_tsv_index in the
> first explain result without any filter on "city_id"?
GIN indexes don't have any particular bias towards earlier or later
Hello, we have some confusion over the planner's use of an index.
Suppose we have a table "parades" with columns:
"city_id" of type integer
"description" of type text
"start_time" of type timestamp without time zone
Suppose also we have indexes:
"parades_city_id_description_tsv_