Index creation - Mailing list pgsql-general

From Дмитрий Иванов
Subject Index creation
Date
Msg-id CAPL5KHq=WCRQY5ZK5VR4JR7cd5si9NPnBxhJibXMCSshMqk9xQ@mail.gmail.com
Whole thread Raw
Responses Re: Index creation
List pgsql-general
Good afternoon.
I have a query parser question. If there are two kinds of queries using an indexed field. In this case, one view is limited to this field, the second one uses a number of fields included in the index by the include directive. It makes sense to have two indexes, lightweight and containing include. Or will the plan rely on the nearest suitable index without considering its weight?
--
Regards, Dmitry!

pgsql-general by date:

Previous
From: jian he
Date:
Subject: Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?
Next
From: "David G. Johnston"
Date:
Subject: Re: Index creation