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  (Matheus de Oliveira <matioli.matheus@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Matheus de Oliveira
Дата:
Сообщение: Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8
Следующее
От: "Wilson, Maria Louise (LARC-E301)[RSES]"
Дата:
Сообщение: Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8