Re: Postgres filling up hard drive with swap files

> Wow, this would be the most spectacular memory leak I have ever seen.
> How do you know these files are related to the Postgres processes?

Because if I stop the Postgres server, the swap files go away and the
hard drive space is freed up.

> Could we see a top extract, or some equivalent showing a process list
> and their memory sizes?

Here's a partial top extract. As noted before, the VSIZE is very high
on all.

Processes: 231 total, 3 running, 228 sleeping... 300 threads
13:05:16
Load Avg: 0.12, 0.07, 0.02 CPU usage: 6.3% user, 15.9% sys, 77.8%
idle
SharedLibs: num = 102, resident = 14.0M code, 1.21M data, 2.77M
LinkEdit
MemRegions: num = 9888, resident = 134M + 7.73M private, 32.9M shared
PhysMem: 78.6M wired, 283M active, 141M inactive, 504M used, 7.82M
free
VM: 12.1G + 70.5M 465206(0) pageins, 1792391(0) pageouts

PID COMMAND %CPU TIME #TH #PRTS #MREGS RPRVT RSHRD RSIZE
VSIZE
14326 top 19.7% 0:03.13 1 17 26 364K 384K 740K
27.1M
14293 bash 0.0% 0:00.13 1 12 18 124K 852K 796K
18.2M
14291 sshd 0.0% 0:00.49 1 15 42 504K 884K 1.43M
30.0M
14290 postgres 0.0% 0:00.31 1 9 32 860K 16.9M 6.90M
59.5M
14289 ftpd 0.0% 0:00.02 1 15 34 152K 640K 772K
27.4M
14264 postgres 0.0% 0:00.31 1 9 32 860K 16.9M 6.32M
59.5M
14235 postgres 0.0% 0:01.36 1 9 33 880K 16.9M 9.62M
60.0M
14224 postgres 0.0% 0:00.27 1 9 32 856K 16.9M 6.26M
59.5M
14220 postgres 0.0% 0:00.24 1 9 32 840K 16.9M 6.50M
59.5M
14218 postgres 0.0% 0:39.17 1 9 32 860K 16.9M 10.7M
59.5M
14113 postgres 0.0% 0:00.21 1 9 32 648K 16.9M 4.69M
59.5M
14075 postgres 0.0% 1:19.88 1 9 33 756K 16.9M 7.84M
60.0M
14063 postgres 0.0% 0:00.46 1 9 33 680K 16.9M 7.38M
60.0M
14061 postgres 0.0% 0:00.18 1 9 32 616K 16.9M 4.48M
59.5M
14058 postgres 0.0% 0:00.60 1 9 33 720K 16.9M 6.53M
60.0M
14055 postgres 0.0% 0:00.17 1 9 32 496K 16.9M 1.77M
59.5M
14028 postgres 0.0% 0:00.18 1 9 32 448K 16.9M 1.68M
59.5M
14015 postgres 0.0% 0:18.61 1 9 33 844K 16.9M 8.61M
60.0M
14013 postgres 0.0% 0:19.65 1 9 33 784K 16.9M 7.21M
60.0M
14009 postgres 0.0% 2:05.01 1 9 33 940K 16.9M 10.9M
60.0M
13980 postgres 0.0% 0:00.47 1 9 32 804K 16.9M 2.70M
59.5M
13444 postgres 0.0% 0:16.70 1 9 33 792K 16.9M 10.7M
60.0M
13415 postgres 0.0% 0:02.03 1 9 33 936K 16.9M 6.74M
60.0M
13409 postgres 0.0% 0:01.75 1 9 32 508K 16.9M 1.96M
59.5M
13355 postgres 0.0% 0:01.75 1 9 33 884K 16.9M 5.50M
60.0M
13339 postgres 0.0% 0:19.49 1 9 33 716K 16.9M 7.21M
60.0M
13337 postgres 0.0% 0:01.93 1 9 33 848K 16.9M 3.56M
60.0M
13321 postgres 0.0% 0:01.88 1 9 33 868K 16.9M 5.89M
60.0M