If I'm using django-postgrespool on a standard shared Postgres database, what are the recommended settings for:
asked 24 Jun '13, 17:08 tclancy |
The settings you will require will depend on, your code, how you plan to use that code, and how the users might use that code in unexpected ways. Thus there are no recommended settings and you would have to experiment to find what works for you, start by researching exactly what each means from the developers documentation, it might be better to ask the developer community of that module for more specific questions as they would likely know more about the details. answered 24 Jun '13, 17:52 johns Fair enough, but the metrics usually have rough recommendations based on hardware setups, can you help me with those? For example, pool size: "number of active connections should be somewhere near ((core_count * 2) + effective_spindle_count)".
(25 Jun '13, 10:38)
tclancy
If you can let us know which server you're on, we'll try to get the info you need. That said, I'm almost certain those calculations assume that PostgreSQL is running on a dedicated DB server, which isn't the case on our setup.
(26 Jun '13, 12:06)
seanf
|