For e.g., I’m having database with huge amount of data,
Every years it increases data with 400k records,
Having big issue is on concurrent update, database integrated with many eCommerce database, and synchronized with my database, which is causing issue on concurrent update,
How could reduce the concurrent update issue, by upgrading servers(Hardware) or any additional configuration.
Any Guidance or suggestion appreciated
Thanks & Regards,
if every years data is increases 400K is not issues because postgres limit is bigger then you think. just provide good hardware like 64GB RAM and i5 or i7 processer. recently i upgraded one server. it is working to faster then older every year my database is increase as 1.2 GB. we are working since last 6 years. so, please choose hardware as high quality RAM. enough to run your server. thanks
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 6/16/16, 9:07 AM|
|Seen: 298 times|
|Last updated: 7/22/16, 9:45 AM|