Forums

Hi there, I'm trying to build a production application that is going to be read heavy on the db (probably like 99% read, 1% write). I use PA for most of my personal apps and I'm familiar with how everything works on this site. I want to build my project that will be production ready soon on PA as well, but I'm concerned that the db won't be powerful enough. I'm running a management command that is looping through every row in the db (450k rows), hitting an external api, writing to the db (multithreaded with 15 threads). While this has been running the database is slowed to a crawl and this is only with 15 threads. I plan on there being a lot more traffic than that in the future. Is the database feature on PA not scalable? Is there a way to split the database into a read DB / a write DB? Should I use another website's managed postgresql service instead of PA's?

Thanks!

It's unlikely that, if you are having those issues, that we can provide a database that matches your needs. Your best bet is probably to use a managed service where you can adjust the resources available to your database to match what you require.