Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8
Дата
Msg-id CANzqJaCMfj+nY6CNaW18tNz6kjP9GC6mTxke36Q5Ff2GeugRuw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8  (Matheus de Oliveira <matioli.matheus@gmail.com>)
Ответы Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8
Список pgsql-admin
Дерево обсуждения
On Thu, Dec 28, 2023 at 2:38 PM Matheus de Oliveira <matioli.matheus@gmail.com> wrote:
[snip] 
PS: As said in the other thread, a primary key on (granule_uuid, file_id) would make more sense, but you need to get rid of null values on these rows before creating the PK.
 
Can't you create a unique index index on fields with nulls?

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