Hope you can help.
I took a snapshot of all the processes on the pc with 'ps axu' every five minutes.
The results were interesting/confusing. I have attached part of the information.
The postmaster creates/spawns/forks a number of /usr/bin/postgres at boot up.
These keep gulping memory. Even a reboot at just allows it to start gulping again.
1.. Memory leak (I think) :
From the attached file particular bits of 'interest' were :
- Around 5:35am and 5:45am on the 16th
September where it supposedly clean's itself up?
- Around 12:50pm of the 16th where one daemon pop's up to 50MB+ (40%
of mem)
The postmaster spawn's these but I don't seem to find the doc to see it's
logic?
What can I use to see to log what's going on?
What can I use to correct it.
2. Duplicate postmaster processes :
Also, if I look at a snapshot of the postmaster, there seems to be multiple
'postmaster' processes alive but they
are not active :
SIZE Virtual image size; size of text+data+stack.
RSS Resident set size; kilobytes of program in memory.
File <Date> - <time> Owner PID ? % SIZE RSS
---- ------------------- -------- ----- --- --- ----- ----
---- ------ --------
test.19990916-020000.log:postgres 333 0.0 0.2 3420 272
? S Sep 9 0:00 /usr/bin/postmaster -
test.19990916-020000.log:postgres 21955 0.0 0.0 3828 0 ? SW
14:05 0:00 (postmaster)
test.19990916-020000.log:postgres 22235 0.0 0.0 3652 0 ? SW
16:10 0:00 (postmaster)
test.19990916-020000.log:postgres 22236 0.0 0.0 3828 0 ? SW
16:10 0:00 (postmaster)
test.19990916-020500.log:postgres 333 0.0 0.2 3420 272 ? S
Sep 9 0:00 /usr/bin/postmaster -
test.19990916-020500.log:postgres 21955 0.0 0.0 3828 0 ? SW
14:05 0:00 (postmaster)
test.19990916-020500.log:postgres 22235 0.0 0.0 3652 0 ? SW
16:10 0:00 (postmaster)
test.19990916-020500.log:postgres 22236 0.0 0.0 3828 0 ? SW
16:10 0:00 (postmaster)
test.19990916-021000.log:postgres 333 0.0 0.2 3420 272 ? S
Sep 9 0:00 /usr/bin/postmaster -
Versions :
$ more /etc/issue
Red Hat Linux release 5.2 (Apollo)
Kernel 2.2.1 on an i686
$ more /var/lib/pgsql/PG_VERSION
6.4
Any help or pointers in the right direction would be great.
Thank you in advance,
Colin PRICE.
<<temp.txt>>
SIZE Virtual image size; size of text+data+stack.
RSS Resident set size; kilobytes of program in memory.
File <Date> - <time> Owner PID % SIZE RSS
---- ------------------- -------- ----- --- --- ----- -----
.
.
.
test.19990916-053000.log:postgres 18083 0.0 1.8 4372 2408 ? S Sep 14 1:52
/usr/bin/postgres loc
test.19990916-053000.log:postgres 18084 0.0 3.3 5908 4296 ? S Sep 14 1:50
/usr/bin/postgres loc
test.19990916-053000.log:postgres 18085 0.0 5.3 35128 6920 ? S Sep 14 1:57
/usr/bin/postgres loc
test.19990916-053000.log:postgres 18086 0.1 2.2 4572 2828 ? S Sep 14 2:28
/usr/bin/postgres loc
test.19990916-053500.log:postgres 18083 0.0 1.8 4372 2408 ? S Sep 14 1:52
/usr/bin/postgres loc
test.19990916-053500.log:postgres 18084 0.0 3.3 5908 4296 ? S Sep 14 1:50
/usr/bin/postgres loc
test.19990916-053500.log:postgres 18085 0.0 5.3 35128 6920 ? S Sep 14 1:57
/usr/bin/postgres loc
test.19990916-053500.log:postgres 18086 0.1 2.2 4572 2828 ? S Sep 14 2:28
/usr/bin/postgres loc
test.19990916-054000.log:postgres 18083 0.0 1.8 4372 2408 ? S Sep 14 1:52
/usr/bin/postgres loc
test.19990916-054000.log:postgres 18084 0.0 3.3 5908 4296 ? S Sep 14 1:50
/usr/bin/postgres loc
test.19990916-054000.log:postgres 18085 0.0 5.3 35128 6920 ? S Sep 14 1:57
/usr/bin/postgres loc
test.19990916-054000.log:postgres 18086 0.1 2.2 4572 2828 ? S Sep 14 2:28
/usr/bin/postgres loc
test.19990916-054500.log:postgres 18083 0.0 1.8 4372 2408 ? S Sep 14 1:52
/usr/bin/postgres loc
test.19990916-054500.log:postgres 18084 0.0 3.3 5908 4296 ? S Sep 14 1:50
/usr/bin/postgres loc
test.19990916-054500.log:postgres 18085 0.0 2.5 7776 3284 ? S Sep 14 1:57
/usr/bin/postgres loc
test.19990916-054500.log:postgres 18086 0.1 2.2 4572 2828 ? S Sep 14 2:28
/usr/bin/postgres loc
test.19990916-055000.log:postgres 18083 0.0 1.8 4372 2408 ? S Sep 14 1:52
/usr/bin/postgres loc
test.19990916-055000.log:postgres 18084 0.0 3.3 5908 4296 ? S Sep 14 1:50
/usr/bin/postgres loc
test.19990916-055000.log:postgres 18085 0.0 3.7 7776 4804 ? S Sep 14 1:57
/usr/bin/postgres loc
test.19990916-055000.log:postgres 18086 0.1 2.2 4572 2828 ? S Sep 14 2:28
/usr/bin/postgres loc
test.19990916-055500.log:postgres 18083 0.0 1.8 4372 2408 ? S Sep 14 1:52
/usr/bin/postgres loc
test.19990916-055500.log:postgres 18084 0.0 3.3 5908 4296 ? S Sep 14 1:50
/usr/bin/postgres loc
test.19990916-055500.log:postgres 18085 0.0 3.7 7776 4804 ? S Sep 14 1:57
/usr/bin/postgres loc
test.19990916-055500.log:postgres 18086 0.1 2.2 4572 2828 ? S Sep 14 2:28
/usr/bin/postgres loc
test.19990916-060000.log:postgres 18083 0.0 1.8 4372 2408 ? S Sep 14 1:52
/usr/bin/postgres loc
test.19990916-060000.log:postgres 18084 0.0 3.3 5908 4296 ? S Sep 14 1:50
/usr/bin/postgres loc
test.19990916-060000.log:postgres 18085 0.0 3.7 7776 4804 ? S Sep 14 1:57
/usr/bin/postgres loc
test.19990916-060000.log:postgres 18086 0.1 2.2 4572 2828 ? S Sep 14 2:28
/usr/bin/postgres loc
.
.
.
test.19990916-122000.log:postgres 388 0.0 2.3 4316 3036 ? S 11:23 0:02
/usr/bin/postgres loc
test.19990916-122000.log:postgres 390 0.0 2.2 4312 2936 ? S 11:23 0:02
/usr/bin/postgres loc
test.19990916-122000.log:postgres 391 0.0 2.3 4320 2956 ? S 11:23 0:02
/usr/bin/postgres loc
test.19990916-122000.log:postgres 392 0.0 2.2 4312 2932 ? S 11:23 0:02
/usr/bin/postgres loc
test.19990916-122000.log:postgres 393 0.0 2.3 4352 3012 ? S 11:24 0:02
/usr/bin/postgres loc
test.19990916-122000.log:postgres 429 0.0 1.6 3780 2144 ? S 11:43 0:00
/usr/bin/postgres loc
test.19990916-122500.log:postgres 388 0.0 2.3 4316 3036 ? S 11:23 0:02
/usr/bin/postgres loc
test.19990916-122500.log:postgres 390 0.0 2.2 4312 2936 ? S 11:23 0:02
/usr/bin/postgres loc
test.19990916-122500.log:postgres 391 0.0 2.3 4320 2956 ? S 11:23 0:02
/usr/bin/postgres loc
test.19990916-122500.log:postgres 392 0.0 2.2 4312 2932 ? S 11:23 0:02
/usr/bin/postgres loc
test.19990916-122500.log:postgres 393 0.0 2.3 4352 3012 ? S 11:24 0:02
/usr/bin/postgres loc
test.19990916-122500.log:postgres 429 0.0 1.6 3780 2144 ? S 11:43 0:00
/usr/bin/postgres loc
test.19990916-123000.log:postgres 388 0.0 2.3 4316 3036 ? S 11:23 0:02
/usr/bin/postgres loc
test.19990916-123000.log:postgres 390 0.0 2.2 4312 2936 ? S 11:23 0:02
/usr/bin/postgres loc
test.19990916-123000.log:postgres 391 0.0 2.3 4320 2956 ? S 11:23 0:02
/usr/bin/postgres loc
test.19990916-123000.log:postgres 392 0.0 2.2 4312 2932 ? S 11:23 0:02
/usr/bin/postgres loc
test.19990916-123000.log:postgres 393 0.0 2.3 4352 3012 ? S 11:24 0:02
/usr/bin/postgres loc
test.19990916-123000.log:postgres 429 0.0 1.6 3780 2144 ? S 11:43 0:00
/usr/bin/postgres loc
test.19990916-123500.log:postgres 388 0.0 2.3 4316 3068 ? S 11:23 0:02
/usr/bin/postgres loc
test.19990916-123500.log:postgres 390 0.0 2.2 4312 2940 ? S 11:23 0:02
/usr/bin/postgres loc
test.19990916-123500.log:postgres 391 0.0 2.3 4320 3012 ? S 11:23 0:03
/usr/bin/postgres loc
test.19990916-123500.log:postgres 392 0.0 2.3 4312 2956 ? S 11:23 0:02
/usr/bin/postgres loc
test.19990916-123500.log:postgres 393 0.0 2.3 4352 3020 ? S 11:24 0:02
/usr/bin/postgres loc
test.19990916-123500.log:postgres 429 0.0 1.6 3780 2144 ? S 11:43 0:00
/usr/bin/postgres loc
test.19990916-124000.log:postgres 388 0.0 2.4 4316 3088 ? S 11:23 0:03
/usr/bin/postgres loc
test.19990916-124000.log:postgres 390 0.0 2.3 4312 3028 ? S 11:23 0:03
/usr/bin/postgres loc
test.19990916-124000.log:postgres 391 0.1 2.4 4364 3136 ? S 11:23 0:04
/usr/bin/postgres loc
test.19990916-124000.log:postgres 392 0.0 2.4 4360 3116 ? S 11:23 0:03
/usr/bin/postgres loc
test.19990916-124000.log:postgres 393 0.0 2.4 4352 3088 ? S 11:24 0:03
/usr/bin/postgres loc
test.19990916-124000.log:postgres 429 0.0 1.6 3780 2144 ? S 11:43 0:00
/usr/bin/postgres loc
test.19990916-124500.log:postgres 388 0.0 2.4 4360 3132 ? S 11:23 0:04
/usr/bin/postgres loc
test.19990916-124500.log:postgres 390 0.0 2.3 4312 3044 ? S 11:23 0:04
/usr/bin/postgres loc
test.19990916-124500.log:postgres 391 0.1 2.4 4364 3136 ? S 11:23 0:05
/usr/bin/postgres loc
test.19990916-124500.log:postgres 392 0.1 2.4 4360 3120 ? S 11:23 0:05
/usr/bin/postgres loc
test.19990916-124500.log:postgres 393 0.0 2.4 4356 3116 ? S 11:24 0:04
/usr/bin/postgres loc
test.19990916-124500.log:postgres 429 0.0 1.6 3780 2144 ? S 11:43 0:00
/usr/bin/postgres loc
test.19990916-125001.log:postgres 388 0.0 0.8 4360 1112 ? S 11:23 0:04
/usr/bin/postgres loc
test.19990916-125001.log:postgres 390 0.2 42.7 57212 54792 ? S 11:23 0:10
/usr/bin/postgres loc
test.19990916-125001.log:postgres 391 0.1 0.9 4440 1192 ? S 11:23 0:06
/usr/bin/postgres loc
test.19990916-125001.log:postgres 392 0.2 1.4 4396 1904 ? S 11:23 0:12
/usr/bin/postgres loc
test.19990916-125001.log:postgres 393 0.0 0.8 4356 1108 ? S 11:24 0:04
/usr/bin/postgres loc
test.19990916-125001.log:postgres 429 0.0 0.3 3780 508 ? S 11:43 0:00
/usr/bin/postgres loc
test.19990916-125500.log:postgres 388 0.1 2.0 4440 2644 ? S 11:23 0:06
/usr/bin/postgres loc
test.19990916-125500.log:postgres 390 0.2 43.1 57212 55308 ? S 11:23 0:11
/usr/bin/postgres loc
test.19990916-125500.log:postgres 391 0.1 1.9 4416 2496 ? S 11:23 0:07
/usr/bin/postgres loc
test.19990916-125500.log:postgres 392 0.2 1.9 4408 2532 ? S 11:23 0:12
/usr/bin/postgres loc
test.19990916-125500.log:postgres 393 0.0 1.9 4404 2476 ? S 11:24 0:05
/usr/bin/postgres loc
test.19990916-125500.log:postgres 429 0.0 0.3 3780 508 ? S 11:43 0:00
/usr/bin/postgres loc
test.19990916-130000.log:postgres 388 0.1 2.0 4440 2644 ? S 11:23 0:06
/usr/bin/postgres loc
test.19990916-130000.log:postgres 390 0.1 43.1 57212 55308 ? S 11:23 0:11
/usr/bin/postgres loc
test.19990916-130000.log:postgres 391 0.1 1.9 4416 2508 ? S 11:23 0:07
/usr/bin/postgres loc
test.19990916-130000.log:postgres 392 0.2 2.0 4408 2604 ? S 11:23 0:12
/usr/bin/postgres loc
test.19990916-130000.log:postgres 393 0.0 1.9 4404 2476 ? S 11:24 0:05
/usr/bin/postgres loc
test.19990916-130000.log:postgres 429 0.0 0.3 3780 508 ? S 11:43 0:00
/usr/bin/postgres loc
test.19990916-130500.log:postgres 388 0.1 2.0 4440 2644 ? S 11:23 0:06
/usr/bin/postgres loc
test.19990916-130500.log:postgres 390 0.1 43.1 57212 55368 ? S 11:23 0:11
/usr/bin/postgres loc
test.19990916-130500.log:postgres 391 0.1 1.9 4420 2560 ? S 11:23 0:07
/usr/bin/postgres loc
test.19990916-130500.log:postgres 392 0.2 2.0 4408 2612 ? S 11:23 0:12
/usr/bin/postgres loc
test.19990916-130500.log:postgres 393 0.0 1.9 4404 2476 ? S 11:24 0:05
/usr/bin/postgres loc
.
.
.
