I’m not actually looking to optimize my EventStore solution, just make it distributed so that database nodes can fail without interrupting service.
Sure, I gotcha there. Optimize wasn’t the right word for the problem.
Anyhow, I figured knowing the requirements of an Event Store would help to deduce what’s required from PostgreSQL specifically.
As stated earlier, I am not a PostgreSQL expert, so I’d leave the specifics on that to others here if you feel PostgreSQL is the way to go for your Event Store.