4 ms·
We’re already in a new paradigm, one in which web devs are abandoning referential integrity guarantees in favor of not having to think about data modeling. I’d
by sgarland 2y ago
We’re already in a new paradigm, one in which web devs are abandoning referential integrity guarantees in favor of not having to think about data modeling.
I’d say they’re then surprised when their DB calls are slow (nothing to do with referential integrity, just the TOAST/DETOAST overhead), but since they also haven’t experienced how fast a DB with local disks and good data locality can be, they have no idea.
- pnt12 2y agoCan you elaborate on what's TOAST/DETOAST?
- davidrowley 2y agoThe Oversized-Attribute Storage Technique. https://www.postgresql.org/docs/17/storage-toast.html https://www.postgresql.org/docs/17/storage-toast.html