Dear Concern,
Always my server memory utilization is remain >99%. I have 4 DB server and
RAM of the server is (32 GB, 64 GB, 64 GB and 132 GB*). In every server
always we are getting the memory utilization > 99%. *Kindly suggest why
this problem is and which parameter will resolve this problem.
I am using PostgreSQL 9.1.2 and PostGIS 1.5 version on every Red hat Linux
server. Kindly find the "TOP" result, "ulimit -a" result,
("kernel.shmax", "kernel.shmall", "kernel.sem" value) and pg_setting result
of one server as below. If you require any other information then inform to
me.
[root@CPPMOMA_DB01 ~]# top
top - 12:08:08 up 15 days, 15:45, 5 users, load average: 1.05, 1.19, 1.35
Tasks: 605 total, 1 running, 604 sleeping, 0 stopped, 0 zombie
Cpu(s): 6.9%us, 2.1%sy, 0.0%ni, 78.3%id, 12.7%wa, 0.0%hi, 0.1%si,
0.0%st
Mem: 32832364k total, 32621168k used, 211196k free, 77572k buffers
[root@CPPMOMA_DB01 ~]# ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 256323
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 4096
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 256323
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
[root@CPPMOMA_DB01 ~]#
kernel.shmmax = 32212254720
kernel.shmall = 1073741824
kernel.sem = 250 32000 100 384
postgres=# SELECT name, source, setting FROM pg_settings WHERE source !=
'default' AND source != 'override' ORDER by 2, 1;
name | source | setting
----------------------------+----------------------+----------------------------------
application_name | client | psql.bin
client_encoding | client | UTF8
archive_command | configuration file | cp %p
/dbkup/momacpp_213_live/%f
archive_mode | configuration file | on
autovacuum | configuration file | on
autovacuum_max_workers | configuration file | 3
checkpoint_segments | configuration file | 200
checkpoint_timeout | configuration file | 300
checkpoint_warning | configuration file | 30
DateStyle | configuration file | ISO, MDY
default_text_search_config | configuration file | pg_catalog.english
effective_cache_size | configuration file | 524288
lc_messages | configuration file | en_US.UTF-8
lc_monetary | configuration file | en_US.UTF-8
lc_numeric | configuration file | en_US.UTF-8
lc_time | configuration file | en_US.UTF-8
listen_addresses | configuration file | *
log_destination | configuration file | stderr
log_directory | configuration file | pg_log
logging_collector | configuration file | on
log_line_prefix | configuration file | %t
log_rotation_age | configuration file | 1440
maintenance_work_mem | configuration file | 1638400
max_connections | configuration file | 2000
max_files_per_process | configuration file | 2000
max_wal_senders | configuration file | 5
port | configuration file | 5432
shared_buffers | configuration file | 1572864
temp_buffers | configuration file | 4096
wal_level | configuration file | archive
work_mem | configuration file | 32768
log_timezone | environment variable | Asia/Kolkata
max_stack_depth | environment variable | 2048
TimeZone | environment variable | Asia/Kolkata
(34 rows)
postgres=#
Regards,
*Sachin Srivastava*
Assistant Technical Lead(Oracle/PostgreSQL) | TSG
*Cyient* | www.cyient.com
