Re: BUG #17189: Index not created when primary key created
| От | David G. Johnston |
|---|---|
| Тема | Re: BUG #17189: Index not created when primary key created |
| Дата | |
| Msg-id | CAKFQuwYf-rNmNenHsT3Vy=v-OMkDtin25yaxcSNwAbxmRki+tA@mail.gmail.com обсуждение исходный текст |
| Ответ на | BUG #17189: Index not created when primary key created (PG Bug reporting form <noreply@postgresql.org>) |
| Ответы |
Re: BUG #17189: Index not created when primary key created
|
| Список | pgsql-bugs |
On Monday, September 13, 2021, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:
Bug reference: 17189
Logged by: Puneet Sharma
Email address: puneet.orcl@gmail.com
PostgreSQL version: 12.0
Operating system: Linux
Description:
I have created the composite primary key which is created successfully but i
am not getting the index against the primary key.
When i created a select query and includes the primary key column it is
going with full table scan. Even i am creating an index on the columns it is
also going with full table scan.
This isn’t a bug, it did create the indexes. The fact that a particular query choose not to use them is not evidence to the contrary.
David J.
В списке pgsql-bugs по дате отправления: