Re:Listen to your to PostgreSQL database in realtime via Web...
by skyde on Thursday May 06, 2021 @12:49AM
(#27059262)
I agree the children entity ID must be already unique without having to use the parent entity id.
It's just that in my experience have the children table primary b-tree sorted on ParentID then childrenID make join much more efficient unless you can use table interleaving like in Google SpannerDB https://cloud.google.com/spanner/docs/schema-and-data-model#...
It's just that in my experience have the children table primary b-tree sorted on ParentID then childrenID make join much more efficient unless you can use table interleaving like in Google SpannerDB https://cloud.google.com/spanner/docs/schema-and-data-model#...