Re: Postgres filling up hard drive with swap files

On Aug 20, 2004, at 2:09 PM, Joe Lester wrote:

>
> H  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

On osx the number to look at isn't vsize, but actually rprvt.  vsize is
its size in virtual memory (basically useless)- rprvt is the size of
its "private memory" - non shared memory. It is a pretty good number to
go by.

But I believe the whole problem is the emac only has 512MB of ram and
you simply don't have enough memory for that many connections.  Even
with each connection sucking up 2MB of memory that is 400MB and as you
can see.. most of them are sucking 4-8MB.

If you cannot upgrade I'd recommend looking into something like pgpool
so you can pool your connections (this results in having a lot fewer
instances of postgres, thus saving tons of memory)

If you watch top I'm guessing you'll see a TON of pagein/pageouts
(watch the numbers change. it displays the difference in parenthesis
after updates)

--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/