2018-06-01 18:52 GMT+02:00 Guyren Howe <guy...@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 >
