5 ms·

Never heard about postgresql being written for hdds. Could you provide a source?

• avmich 8mo 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 7mo ago
    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.
    • avmich 7mo ago
      https://medium.com/@tusharmalhotra_81114/how-ssds-transformed-database-architecture-from-mysqls-hdd-legacy-to-rocksdb-and-525821c0ec53 https://medium.com/@tusharmalhotra_81114/how-ssds-transforme...
      • phanimahesh 7mo ago
        That blog post is very light on details can be condensed to a single line/paragraph. LSM trees are more efficient for SSDs and modern databases use them. I don't know enough to comment yet but will go read about it.