0000553: transaction mode in pgpool - Pgpool-II Bug Tracker

ID	Project	Category	View Status	Date Submitted	Last Update

0000553	Pgpool-II	General	public	2019-10-11 10:51	2019-10-29 13:24

Reporter	sebastianwebber	Assigned To
Priority	normal	Severity	minor	Reproducibility	N/A
Status	resolved	Resolution	open
Product Version	3.6.17

Summary	0000553: transaction mode in pgpool
Description	Hi Everyone, first of all, please forgive me if this bug tracker is not the proper place to ask questions. In my current environment, I'm using both pgpool and pgbouncer. Basically our application connects on pgbouncer, which connects on pgpool and pgpool parses the queries and route them between our primary server and the database replicas. I was wondering if can we use pgpool in the same "transaction mode"[1] that pgbouncer does. is this possible? btw, transaction mode means that the pool only holds the connection during a transaction and when it ends the connection is put back on the pool, making it available for other connections. I saw that the connection_cache and max_pool[2] parameters can enable a "connection cache" but its not clear if they work in the same way. Thanks for your help! [1] http://www.pgbouncer.org/config.html#pool_mode [2] https://www.pgpool.net/docs/latest/en/html/runtime-config-connection.html#GUC-NUM-INIT-CHILDREN
Steps To Reproduce	NA
Tags	No tags attached.

Date Modified	Username	Field	Change
2019-10-11 10:51	sebastianwebber	New Issue
2019-10-17 08:59	pengbo	Note Added: 0002930
2019-10-29 13:24	pengbo	Status	new => resolved

pengbo 2019-10-17 08:59 developer ~0002930	> I was wondering if can we use pgpool in the same "transaction mode"[1] that pgbouncer does. is this possible? No. Pgpool-II doesn't have "transaction mode".