I noticed that it's a single Postgres instance per account across all web apps. Is it advisable to maintain multiple sites (each with their own PG DB) in a single PA account?
I'm guessing this is a "it depends" question, but I'd love to get a better understanding of the factors to consider if so.
That's an interesting question! Like you say, it is very much an "it depends" kind of thing -- primarily on the details of the load the sites are putting on the Postgres server.
I'd say that the best thing would be to see how things go with multiple sites, and if you're starting to see a slowdown, you could open a new account, create a new Postgres instance, and then migrate the data across.
Sorry I can't give more solid advice!
No worries giles!
What would you recommend to monitor (incl. tools if any) in order to detect "slowdowns"?
Another good question! We don't have anything built in. Pingdom have a page speed monitoring tool that might be useful. And different web frameworks also often have plugins that allow you to track page load time -- for example, these Django plugins.
giles
|
12671
posts
|
PythonAnywhere staff
|
