[pgpool-general: 4692] Re: pools vs connections

Henrik Uggla Henrik.Uggla at kristianstad.se
Sat May 21 02:10:02 JST 2016


But right now we have the following configuration which I thought was "many pools with one connection each". Could you please explain how our current config handle pools and connections.

/Henrik

#------------------------------------------------------------------------------
# POOLS
#------------------------------------------------------------------------------

# - Pool size -

num_init_children = 220
                                   # Number of pools
                                   # (change requires restart)
max_pool = 1
                                   # Number of connections per pool
                                   # (change requires restart)

________________________________________
Från: Tatsuo Ishii <ishii at postgresql.org>
Skickat: den 20 maj 2016 16:34
Till: Henrik Uggla
Kopia: pgpool-general at pgpool.net
Ämne: Re: [pgpool-general: 4689] pools vs connections

> Hi!
>
>
> We have an web application which starts a whole bunch (100+) of concurrent database connections. All connections is within the same server, to the same database and with the same credentials, only read operations, no write. Which configuration would yield the best performance? One pool with many connections or many pools with one connection each?

Pgpool-II does not provide "many pools with one connection each" type
of configuration. The only configuration you can use is "One pool with
many connections".

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


More information about the pgpool-general mailing list