Apologies for the beginner question.
I have a couple of AWS Postgres databases that will be receiving a few thousand writes a second on the day of an event.
I also need to make read queries against the database. These would obviously be better with indexes, but adding these indexes will slow down the writes too much.
I would like to set up replication of the original Postgres databases on AWS to allow performant reads without affecting performant writes.
I know that I can't do physical replication because I won't be able to add indexes. However, is doing logical replication and adding indexes on the replicas a good approach?
Or is there a better way to approach this?
