|
|
|
|
|
by tetha
1004 days ago
|
|
At 7500 records a day, I'd even question RabbitMQ in the design. If I was to judge that at work, my first thought would be that one of our busier postgres clusters with 2 read replicas is chugging through some 2-3k transactions per second without really needing much tuning or rather specialized hardware. The more ETL-oriented clusters are capable of processing some 100M - 200M rows per second when chugging through large queries, and these are just simple 4 core VMs again on not really specialized hardware. And postgres would parallelize these queries more if you gave it more cores and the queries aren't horrible. At 7500 records a day or 3 million a year, you wouldn't be able to generate enough data to make one of these databases sweat over many years. Hate me as a DBA, but write some good queries for whatever you're doing and run those in a cronjob at that scale. |
|