Postgres Pro
Downloads
Home   >   mailing lists

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

From Ron Johnson
Subject Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8
Date
Msg-id CANzqJaCMfj+nY6CNaW18tNz6kjP9GC6mTxke36Q5Ff2GeugRuw@mail.gmail.com
Whole thread Raw
In response to Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8  (Matheus de Oliveira <matioli.matheus@gmail.com>)
Responses Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8
List pgsql-admin
Tree view
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 by date:

Previous
From: Matheus de Oliveira
Date:
Subject: Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8
Next
From: "Wilson, Maria Louise (LARC-E301)[RSES]"
Date:
Subject: Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8