On: Postgres Full Text Search vs. the Rest

[sroussey]

Yes, but paged b-trees are more graceful when they can’t fit in memory—which was the default when I cut my teeth on databases.

It’s also a reason why MyIsam separated data and index files. InnoDb is a clustered index, so all the data is packed next to the primary key.