Re: Use of multi-column gin index

2019-06-03 Thread Tom Lane
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

Use of multi-column gin index

2019-06-03 Thread Jared Rulison
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: