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

Поиск
Список
Период
Сортировка
От Matheus de Oliveira
Тема Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8
Дата
Msg-id CAJghg4JB-5GH=UOiXtjBsxfVq+Ud2SABww8CiDwLUeKcSox=Ew@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8  (Ron Johnson <ronljohnsonjr@gmail.com>)
Список pgsql-admin
Дерево обсуждения


On Thu, Dec 28, 2023 at 4:42 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
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?

Yes, you can create an unique index on fileds with nulls. But not a primary key, a primary key requires that all fiedls are NOT NULL.

Best regards,
--
Matheus de Oliveira


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

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