[pgpool-general: 7612] Re: Pool status check

[Bo Peng]

Hello,

On Thu, 1 Jul 2021 11:44:50 +0530
valsaraj pv <valsarajpv at gmail.com> wrote:

> Hi,
> 
> postgres=# SHOW POOL_POOLS;
>  pool_pid |     start_time      | pool_id | backend_id |       database
>    | username |     create_time     | majorversion | minorversion
> | pool_counter | pool_backendpid | pool_connected
> ----------+---------------------+---------+------------+-----------------------+----------+---------------------+--------------+--------------
> +--------------+-----------------+----------------
> 
>  141705   | 2021-07-01 01:51:20 | 0       | 0          | postgres
>    | postgres  | 2021-07-01 02:04:36 | 3            | 0
> | 1            | 154957          | 1
>  141705   | 2021-07-01 01:51:20 | 0       | 1          | postgres
>    | postgres  | 2021-07-01 02:04:36 | 3            | 0
> | 1            | 121689
> 
> Here pool_pid is the same for both entries but pool_backendpid is
> different.
> Anyone please help me to understand what are 2 different ids.

Because Pgpool-II generates connections to all PostgreSQL backends.
If you have configured 2 PostgreSQL backends in Pgpool-II, Pgpool-II
will generate connection to each PostgreSQL backend (2 processes).

> Also if we use postgres DB, connection_cache can be off since pgpool won't
> cache connections to postgres DB?

You can turn off connection cache using "connection_cache = off".

-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
http://www.sraoss.co.jp/