I have to create a DB which has around 130 million records which is around 90GB when loaded. I want to host this in the azure. DB modifications will happen once a day as a batch operation. Searching has to be done more often which should return the results within 2 seconds. Search includes text search (address) and a few other numerical fields.
I'm trying to figure out the most cost effective database but providing above mentioned performance. I've tested Single server PostgreSQL DB but the performance is terrible even after I added
General Purpose Gen-5 4 cores (20GB RAM) and 500GB storage (1500 IOPS).
(I've used indexes for the search parameters already)
Is SQL server a good alternative?