On 7/19/2005 2:55 PM, Ian Burrell wrote:

> We have a three node slony cluster.  Two of the slon daemons for the
> slave nodes have large memory usage: virtual size of 2991 MB and 2214
> MB.  Luckily, the machine has 16 GB of RAM. These are 32-bit processes
> and only have 3 GB of virtual memory per process so they are getting
> close to running out of their own memory.

This is very unusual. I have not seen slon processes over 30MB size thus 
far.

What are the exact version numbers of slon and libpq? Is there anything 
special about the database (huge tuple sizes for example)?


Jan


> 
> Here is the ps listing:
> 
> USER       PID %CPU %MEM   VSZ  RSS TTY      STAT START   TIME COMMAND
> imb      23278  0.0  0.0  2168  756 ?        S    Jul16   0:00 slon -s
> 1000 -d2 -g 80 vodslony host=voddb1 dbname=vodlive user=slony
> port=5432
> imb      23280  0.0  0.0 85812 1548 ?        S    Jul16   1:46 slon -s
> 1000 -d2 -g 80 vodslony host=voddb1 dbname=vodlive user=slony
> port=5432
> imb      23362  0.0  0.0  2196  812 ?        S    Jul16   0:00 slon -s
> 1000 -d2 -g 80 vodslony host=voddb4 dbname=vodlive_slave2 user=slony
> port=5432
> imb      23370  0.4 13.6 3063396 2191596 ?   S    Jul16  16:41 slon -s
> 1000 -d2 -g 80 vodslony host=voddb4 dbname=vodlive_slave2 user=slony
> port=5432
> imb      17706  0.0  0.0  2188  828 ?        S    Jul18   0:00 slon -s
> 1000 -d2 -g 80 vodslony host=voddb3 dbname=vodlive_slave1 user=slony
> port=5432
> imb      17714  0.1  9.7 2268024 1565852 ?   S    Jul18   2:06 slon -s
> 1000 -d2 -g 80 vodslony host=voddb3 dbname=vodlive_slave1 user=slony
> port=5432
> 
> Is there a known cause of the memory usage?  Is there a memory leak? 
> Is there anything we can do debug this?
> 
>  - Ian
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general


-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #