[pgpool-general: 3836] Re: Configuration / Out of Memory / no connection more from connections pool.
ishii at postgresql.org
Sun Jun 28 12:30:04 JST 2015
Sounds like you don't have enough resource for the configuration.
Assuming your pgpool and PostgreSQL lives on a same server, 500
num_init_children * 4 max_pool * 256MB maintenance_work_mem = 512000MB
= 500GB. Plus you need 500 pgpool process memory. That heavily
depends on OS, but my experience with Ubuntu showed that 888MB for 32
pgpool process (num_init_children). That suggests 13GB of memory.
How much memory and swap space do you have on the server?
SRA OSS, Inc. Japan
> Hello PGPOOL Admins,
> I have a problem with the configuration the database with connection pool pgpool II Version 3.3.4 and PostgreSQL 9.1 on the SUSE Enterprice Linux Server. I configure the pgpool.conf as follow:
> num_init_children = 500
> max_pool = 4
> and the configurations of postgresql are:
> max_connections = 4000
> shared_buffers = 1024MB
> work_mem = 3MB #[1MB] # min 64kB
> maintenance_work_mem = 256MB #[16MB] # min 1MB
> max_stack_depth = 3MB #[2MB]
> checkpoint_segments = 16 # # in logfile segments, min 1, 16MB each
> checkpoint_timeout = 5min # range 30s-1h
> checkpoint_completion_target = 0.9 #
> max_wal_senders = 2
> effective_cache_size = 1024MB
> log_autovacuum_min_duration = 60s
> log_temp_files = 10MB
> log_lock_waits = off # log lock waits >= deadlock_timeout
> log_statement = 'all'
> die configuration in the file "sysctl.conf" are:
> # Disable response to broadcasts.
> # You don't want yourself becoming a Smurf amplifier.
> net.ipv4.icmp_echo_ignore_broadcasts = 1
> # enable route verification on all interfaces
> net.ipv4.conf.all.rp_filter = 1
> # enable ipV6 forwarding
> #net.ipv6.conf.all.forwarding = 1
> # increase the number of possible inotify(7) watches
> fs.inotify.max_user_watches = 65536
> # avoid deleting secondary IPs on deleting the primary IP
> net.ipv4.conf.default.promote_secondaries = 1
> net.ipv4.conf.all.promote_secondaries = 1
> my problem the cached of the PostgreSQL-DB Server increasing with the time till swap start it. Then comes Out of memory and no connection more from connections pool.
> Any help will be gratefull
More information about the pgpool-general