Implementation Details of Postgres Databases

In Postgres, if you update something on a record and that update can fit on the same page file in the index, they don't have to change anything. So this all comes down to implementation details. And another database might do it different. But yeah, those nodes would technically be pointers to other files like, oh, for this, you know, for records one through 50, they're over into this file for 51 through 100,. It's pointers to the individual file. The natural in 2023 is going to let put this kind of spreadsheet kind of view of the into somebody's mind," he says.