Postgres is an academic experiment and every time I've seen someone attempt to scale it, it ends in tears.  Salty, salty tears, and massive amounts of un-necessary hardware deployed in an attempt to stop the mysterious bleeding out of its performance under a high rate of queries.  Maybe postgres Jesus will join the org and save it somehow, but he never does.  Anyway, MySQL is better, and lmdb seems best for what nostr is doing (serving notes directly from a memory mapped cache).

 

 MySQL is better? lol no. Not true at all.

NoSQL like Scylla or Cassandra would be the better choice. 

Sure, LMBD serves a lot from memory mapped cache but for some reason, IO is still way higher than competing technologies. 

Postgres is much lighter for IO for NOstr's use case.