Memory Utilization Issue

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(at)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(at)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(at)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