Remix.run Logo
avmich 3 hours ago

Well, take a look at the dates of when Postgres was created and when SSDs become available. Better, find articles about internal algorithms, B-trees, times of operations like seeks etc. The Postgres was initially written with disk operation timings in mind, and the point is that's changing - and I haven't heard of Postgres architecture changing with that.

phanimahesh an hour ago | parent [-]

Can you share examples of new database architectures and products using them that are built for SSDs?

I'm sure we have different capabilities and constraints, but I am unaware of any fundamentally different approaches to indexes.