Skip site navigation (1) Skip section navigation (2)

Re: Postgres filling up hard drive with swap files

From: Joe Lester <joe_lester(at)sweetwater(dot)com>
To: postgres list <pgsql-general(at)postgresql(dot)org>
Cc: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Subject: Re: Postgres filling up hard drive with swap files
Date: 2004-08-20 18:09:38
Message-ID: 197B34DA-F2D4-11D8-BDD7-000A95A58EA0@sweetwater.com (view raw or flat)
Thread:
Lists: 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



In response to

Responses

pgsql-general by date

Next:From: Bruce MomjianDate: 2004-08-20 18:14:04
Subject: Re: How to setup default value "0000-00-00" for "date"
Previous:From: Tom LaneDate: 2004-08-20 17:51:55
Subject: Re: How to setup default value "0000-00-00" for "date"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group