WebFaction
Community site: login faq

If I'm using django-postgrespool on a standard shared Postgres database, what are the recommended settings for:

  • max_overflow
  • pool_size
  • recycle

asked 24 Jun '13, 17:08

tclancy
861815
accept rate: 6%


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.

permanent link

answered 24 Jun '13, 17:52

johns
5.4k412
accept rate: 23%

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
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×909
×109
×1

question asked: 24 Jun '13, 17:08

question was seen: 5,587 times

last updated: 26 Jun '13, 12:06

WEBFACTION
REACH US
SUPPORT
AFFILIATE PROGRAM
LEGAL
© COPYRIGHT 2003-2020 SWARMA LIMITED - WEBFACTION IS A SERVICE OF SWARMA LIMITED
REGISTERED IN ENGLAND AND WALES 5729350 - VAT REGISTRATION NUMBER 877397162
5TH FLOOR, THE OLD VINYL FACTORY, HAYES, UB3 1HA, UNITED KINGDOM