Hi, I'm running Pyramid + SQLAlchemy + PostgreSQL in a "classic" sync stack (like the cookiecutter one, pyramid_tm, etc.), simple gunicorn default (process) workers.
I have a few problems (via pg_top or ps aux): 1. I'm getting about 2x the number of PostgreSQL connections as the number of workers. Is this normal? 2. About half of the connections are in "idle in transaction" state. They shouldn't be in transaction, right? So for --workers=1 I get one idle and one idle in transaction connection. 3. PGSQL 9.6+ supports idle_in_transaction_session_timeout https://www.postgresql.org/docs/9.6/static/runtime-config-client.html#GUC-IDLE-IN-TRANSACTION-SESSION-TIMEOUT Is this a good idea to use this to clean those idle in transaction connections? Should I use something else to close the normal, idle connections as well? Is this a good idea? Would Pyramid reconnect if needed? Zsolt -- You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/pylons-discuss/8cc52db3-3f5a-43b9-b4e1-4b1b1a6149e8%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
