Index creation

From: Дмитрий Иванов <firstdismay(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Index creation
Date: 2022-06-19 19:05:45
Message-ID: CAPL5KHq=WCRQY5ZK5VR4JR7cd5si9NPnBxhJibXMCSshMqk9xQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2022-06-19 19:08:20 Re: Index creation
Previous Message jian he 2022-06-19 10:06:31 Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?