BUG #17189: Index not created when primary key created

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #17189: Index not created when primary key created
Дата
Msg-id 17189-521a1b29d9727929@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #17189: Index not created when primary key created  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: BUG #17189: Index not created when primary key created  (hubert depesz lubaczewski <depesz@depesz.com>)
Re: BUG #17189: Index not created when primary key created  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
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.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #17186: In connect.c, the lock connections_mutex is not correctly released(Line 463) at the return(Line 522)
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17190: lock contention high in postgreSQL13.3 wrt GCC/llvm