3 ms·
This [0] is what I used months ago to test this very thing (although missing UUIDv7, but I’ve done more casual tests and agree with the findings); it’s not quit
by sgarland 3y ago
This [0] is what I used months ago to test this very thing (although missing UUIDv7, but I’ve done more casual tests and agree with the findings); it’s not quite bare metal, but Proxmox in my homelab is unlikely to suffer much, if any stealing.
Results here [1].
Note that this used \COPY instead of INSERT so it bypasses a good bit of logic normally present, but the difference remains stark. Random page hits on a B+tree are always going to suck.
[0]: https://gist.github.com/stephanGarland/fe0788cf2332d6e241ff3ac6d9440caf https://gist.github.com/stephanGarland/fe0788cf2332d6e241ff3...
[1]: https://gist.github.com/stephanGarland/ee38c699a9bb999894d760a10c227bc4 https://gist.github.com/stephanGarland/ee38c699a9bb999894d76...