4 ms·
PostgreSQL has Ltree http://patshaughnessy.net/2017/12/13/saving-a-tree-in-postgres-using-ltree http://patshaughnessy.net/2017/12/13/saving-a-tree-in-postgr...
by thawab 5y ago
PostgreSQL has Ltree
http://patshaughnessy.net/2017/12/13/saving-a-tree-in-postgres-using-ltree http://patshaughnessy.net/2017/12/13/saving-a-tree-in-postgr...
- jitl 5y agoLtree is interesting, but if I understand correctly, to move a parent block, I'd also need to update the path column in all the child blocks -- at our scale such write amplification is a non-starter.