I'm looking to write about 1100 rows per second to tables up to 100 million rows. I'm trying to come up with a design that I can do all the writes to a database with no indexes. When having indexes the write performance slows down dramatically after the table gets bigger than 30 million rows.
I was thinking of having a server dedicated for all the writes and have another server for reads that has indexes and use logical replication to update the read only server.
Would that work? Or any recommendations how I can achieve good performance for a lot of writes?
Thank you