It’s been very snappy today, nice work! Is it all under Docker Compose with the node handling Nginx and Postgres as well?

True, but that would likely require some code changes in Lemmy to segregate read queries and avoid using the replica if it’s a transaction that might read and write.

If Postgres becomes the bottleneck I wonder whether something like Citus could work to shard the data (relatively) transparently?