View Issue Details

IDProjectCategoryView StatusLast Update
0000553Pgpool-II[All Projects] Generalpublic2019-10-29 13:24
ReportersebastianwebberAssigned To 
PrioritynormalSeverityminorReproducibilityN/A
Status resolvedResolutionopen 
Product Version3.6.17 
Target VersionFixed in Version 
Summary0000553: transaction mode in pgpool
DescriptionHi 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 ReproduceNA
TagsNo tags attached.

Activities

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".

Issue History

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