> How about cat /proc/<pid>/limits for the postmaster? > And maybe: > status > stat > maps > > Though I'm kinda grasping at straws here, to be honest. I've had PG up > and running through >16G of memory at a time before. There is no /prod/<pid>/limits file, but here are status: Name: postmaster State: S (sleeping) SleepAVG: 95% Tgid: 4698 Pid: 4698 PPid: 1 TracerPid: 0 Uid: 26 26 26 26 Gid: 26 26 26 26 FDSize: 1024 Groups: 26 VmPeak: 4301216 kB VmSize: 4301204 kB VmLck: 0 kB VmHWM: 85980 kB VmRSS: 85980 kB VmData: 940 kB VmStk: 84 kB VmExe: 4480 kB VmLib: 3512 kB VmPTE: 284 kB StaBrk: 00ade000 kB Brk: 0c3db000 kB StaStk: 7fff21fecf40 kB Threads: 1 SigQ: 0/139264 SigPnd: 0000000000000000 ShdPnd: 0000000000000000 SigBlk: 0000000000000000 SigIgn: 0000000001303000 SigCgt: 0000000000014a07 CapInh: 0000000000000000 CapPrm: 0000000000000000 CapEff: 0000000000000000 Cpus_allowed: 7fffffff,ffffffff,ffffffff,ffffffff,ffffffff,ffffffff,ffffffff,ffffffff Mems_allowed: 00000000,00000001 stat: 4698 (postmaster) S 1 4686 4686 0 -1 4202496 27092033 7777059343 31 2809 6684 47834 13037706 1828097 15 0 1 0 9296 4404432896 21495 18446744073709551615 4194304 8778268 140733763735360 18446744073709551615 232627404115 0 0 19935232 84487 0 0 0 17 2 0 0 69 maps: 00400000-00860000 r-xp 00000000 08:03 1120168 /opt/lms/64/postgres/8.3/bin/postgres 00a5f000-00a6b000 rw-p 0045f000 08:03 1120168 /opt/lms/64/postgres/8.3/bin/postgres 00a6b000-00ade000 rw-p 00a6b000 00:00 0 0c39c000-0c3db000 rw-p 0c39c000 00:00 0 3012200000-3012234000 r-xp 00000000 08:07 5237058 /usr/lib64/libxslt.so.1.1.17 3012234000-3012433000 ---p 00034000 08:07 5237058 /usr/lib64/libxslt.so.1.1.17 3012433000-3012435000 rw-p 00033000 08:07 5237058 /usr/lib64/libxslt.so.1.1.17 3012a00000-3012a05000 r-xp 00000000 08:07 457029 /lib64/libcrypt-2.5.so 3012a05000-3012c04000 ---p 00005000 08:07 457029 /lib64/libcrypt-2.5.so 3012c04000-3012c05000 r--p 00004000 08:07 457029 /lib64/libcrypt-2.5.so 3012c05000-3012c06000 rw-p 00005000 08:07 457029 /lib64/libcrypt-2.5.so 3012c06000-3012c34000 rw-p 3012c06000 00:00 0 3629600000-362961a000 r-xp 00000000 08:07 457227 /lib64/ld-2.5.so 3629819000-362981a000 r--p 00019000 08:07 457227 /lib64/ld-2.5.so 362981a000-362981b000 rw-p 0001a000 08:07 457227 /lib64/ld-2.5.so 3629a00000-3629b46000 r-xp 00000000 08:07 457228 /lib64/libc-2.5.so 3629b46000-3629d46000 ---p 00146000 08:07 457228 /lib64/libc-2.5.so 3629d46000-3629d4a000 r--p 00146000 08:07 457228 /lib64/libc-2.5.so 3629d4a000-3629d4b000 rw-p 0014a000 08:07 457228 /lib64/libc-2.5.so 3629d4b000-3629d50000 rw-p 3629d4b000 00:00 0 3629e00000-3629e02000 r-xp 00000000 08:07 457229 /lib64/libdl-2.5.so 3629e02000-362a002000 ---p 00002000 08:07 457229 /lib64/libdl-2.5.so 362a002000-362a003000 r--p 00002000 08:07 457229 /lib64/libdl-2.5.so 362a003000-362a004000 rw-p 00003000 08:07 457229 /lib64/libdl-2.5.so 362aa00000-362aa82000 r-xp 00000000 08:07 457235 /lib64/libm-2.5.so 362aa82000-362ac81000 ---p 00082000 08:07 457235 /lib64/libm-2.5.so 362ac81000-362ac82000 r--p 00081000 08:07 457235 /lib64/libm-2.5.so 362ac82000-362ac83000 rw-p 00082000 08:07 457235 /lib64/libm-2.5.so 362b600000-362b614000 r-xp 00000000 08:07 5231431 /usr/lib64/libz.so.1.2.3 362b614000-362b813000 ---p 00014000 08:07 5231431 /usr/lib64/libz.so.1.2.3 362b813000-362b814000 rw-p 00013000 08:07 5231431 /usr/lib64/libz.so.1.2.3 362ba00000-362bb33000 r-xp 00000000 08:07 5235374 /usr/lib64/libxml2.so.2.6.26 362bb33000-362bd33000 ---p 00133000 08:07 5235374 /usr/lib64/libxml2.so.2.6.26 362bd33000-362bd3c000 rw-p 00133000 08:07 5235374 /usr/lib64/libxml2.so.2.6.26 362bd3c000-362bd3d000 rw-p 362bd3c000 00:00 0 2aaaaaaab000-2aaaaaaac000 rw-p 2aaaaaaab000 00:00 0 2aaaaaabd000-2aaaaaac1000 rw-p 2aaaaaabd000 00:00 0 2aaaaaac1000-2aaaaaacb000 r-xp 00000000 08:07 456988 /lib64/libnss_files-2.5.so 2aaaaaacb000-2aaaaacca000 ---p 0000a000 08:07 456988 /lib64/libnss_files-2.5.so 2aaaaacca000-2aaaaaccb000 r--p 00009000 08:07 456988 /lib64/libnss_files-2.5.so 2aaaaaccb000-2aaaaaccc000 rw-p 0000a000 08:07 456988 /lib64/libnss_files-2.5.so 2aaaaaccc000-2aaaae299000 r--p 00000000 08:07 5229018 /usr/lib/locale/locale-archive 2aaaae299000-2aabafc41000 rw-s 00000000 00:08 0 /SYSV0063da81 (deleted) 7fff21fda000-7fff21fef000 rw-p 7fff21fda000 00:00 0 [stack] ffffffffff600000-ffffffffffe00000 ---p 00000000 00:00 0 [vdso] Hope this helps, Matt -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
