Postgres Pro
Downloads
Home   >   mailing lists

Re: Whither 1:1? - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Whither 1:1?
Date
Msg-id CAFj8pRCUeo7iWB=Zv-FsvzcAHRLHM5tAWupBN7DHcaP95Gx1cw@mail.gmail.com
Whole thread Raw
In response to Whither 1:1?  (Guyren Howe <guyren@gmail.com>)
List pgsql-general
Tree view


2018-06-01 18:52 GMT+02:00 Guyren Howe <guyren@gmail.com>:
It’s come to my attention that what seems an obvious and useful database design pattern — 1:1 relations between tables by having a shared primary key — is hardly discussed or used.

It would seem to be a very simple pattern, and useful to avoid storing nulls or for groups of fields that tend to be used together.

Thoughts? Is there some downside I can’t see?

Postgres has not multi table statistics - every JOIN increase estimation error.

Regards

Pavel

pgsql-general by date:

Previous
From: James Keener
Date:
Subject: Re: Whither 1:1?
Next
From: Guyren Howe
Date:
Subject: Re: Whither 1:1?