Re: Query optimiser is not using 'not null' constraint when 'order bynulls last' clause is used - Mailing list pgsql-performance

From Nandakumar M
Subject Re: Query optimiser is not using 'not null' constraint when 'order bynulls last' clause is used
Date
Msg-id CANcFUu7o+xcppnDyjf64+BgmjjzT6me_G5spqAOwipU6hUNdvg@mail.gmail.com
Whole thread Raw
In response to Re: Query optimiser is not using 'not null' constraint when 'order bynulls last' clause is used  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-performance
Hi,

On Fri, Feb 2, 2018 at 9:28 PM, David G. Johnston
<david.g.johnston@gmail.com> wrote:

> You probably can (I assume the nulls aspect of the index doesn't prevent PK
> usage), but you must add the PK to the table after creating the index and
> not let the system auto-generate the index for you.
>
> https://www.postgresql.org/docs/10/static/sql-altertable.html
>
> ALTER TABLE name ADD PRIMARY KEY USING INDEX index_name;
>

I missed to notice this in the docs. Thank you David for pointing it out.

Regards,
Nanda


pgsql-performance by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Query optimiser is not using 'not null' constraint when 'order bynulls last' clause is used
Next
From: Vitaliy Garnashevich
Date:
Subject: Re: effective_io_concurrency on EBS/gp2