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