3 ms·
> then you’re still dealing with a B+tree Absolutely, though they're generally orders of magnitude smaller than the table file unless you're INCLUDE'ing lots o
by tomnipotent 2y ago
> then you’re still dealing with a B+tree
Absolutely, though they're generally orders of magnitude smaller than the table file unless you're INCLUDE'ing lots of columns.
There's pg_bulkload which supports parallel writers as well as deferred index updates until the loading process is complete. Not sure how it compares to what MySQL offers out of the box, but I definitely agree that the MySQL tooling ecosystem in general has a leg up.