logoalt Hacker News

avmichtoday at 2:02 AM1 replyview on HN

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.


Replies

phanimaheshtoday at 3:58 AM

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.