Re: Postgres filling up hard drive with swap files - Mailing list pgsql-general

> 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