Hi,
We are facing issue with the RES memory. Below is the o/p of
top command. It shows that writer process reserved 3.8g. We have observed that
if it increased to 3.9g we need to restart the db. Otherwise it hangs. Kindly
suggest us the good way to figure it out this issue. shared_buffer
is 3 GB.
PID USER PR
NI VIRT RES
SHR S %CPU %MEM TIME+ COMMAND
4822 postgres 15 0
4045m 3.8g 3.8g S 0.7 12.1
2:09.63 postgres: writer process
18860 postgres
15 0 12868 1276 816 R
0.7 0.0 0:00.43 top
4825 postgres 15 0
86904 2648 660 S 0.3
0.0 0:25.32 postgres: stats
collector process
3992 postgres 15 0
88220 1848 1104 S 0.0 0.0
0:00.09 sshd: postg...@pts/11
3993 postgres 15 0
66060 1628 1200 S 0.0 0.0
0:00.02 -bash
--Thanks
Sam Jas
Connect more, do more and share more with Yahoo! India Mail. Learn more.
http://in.overview.mail.yahoo.com/
