Postgres Pro
Downloads
Home   >   mailing lists

Re: uniqueness and null could benefit from a hint for dba - Mailing list pgsql-docs

From Bruce Momjian
Subject Re: uniqueness and null could benefit from a hint for dba
Date
Msg-id 20191024143144.GE8650@momjian.us
Whole thread Raw
In response to Re: uniqueness and null could benefit from a hint for dba  (Tuomas Leikola <tuomas.leikola@gmail.com>)
Responses Re: uniqueness and null could benefit from a hint for dba  (Tuomas Leikola <tuomas.leikola@gmail.com>)
List pgsql-docs
Tree view 
On Wed, Oct 23, 2019 at 02:35:02PM +0300, Tuomas Leikola wrote:
> That is a nice design. You can create a regular unique index where columns(s)s
> are not null and then filtered index(es) for the cases where some of the unique
> columns are null.
> 
> However my point, specifically, was that if the document in question would have
> offered alternative solutions, I personally would have been saved from some
> frustration and an exercise in bad index design (I had 5 nullables that need
> uniqueness for the null as well). Maybe it would help someone else.

Uh, I am wondering if it is just too details for our docs.  Can you
think of some text and its location?

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +

pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: wal_sender_timeout / wal_receiver_timeout - seconds or milliseconds?
Next
From: PG Doc comments form
Date:
Subject: Instead of using the bloom index, a parallel sequencial scan is used with this example