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

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8
Date: 2023-12-28 19:42:25
Message-ID: CANzqJaCMfj+nY6CNaW18tNz6kjP9GC6mTxke36Q5Ff2GeugRuw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Dec 28, 2023 at 2:38 PM Matheus de Oliveira <
matioli(dot)matheus(at)gmail(dot)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?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wilson, Maria Louise (LARC-E301)[RSES] 2023-12-28 20:16:46 Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8
Previous Message Matheus de Oliveira 2023-12-28 19:38:10 Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8