I'm running postgrSQL 7.2 on a linux Red Hat 8.0 box with 2GB of RAM
When I boot-up the system , this is the TOP situation:

11:59am  up 4 min,  1 user,  load average: 0.37, 0.26, 0.11

77 processes: 74 sleeping, 3 running, 0 zombie, 0 stopped

CPU states:  0.3% user,  0.7% system,  0.0% nice, 98.8% idle

Mem:  1031020K av,  177808K used,  853212K free,       0K shrd,   14744K buff

Swap: 2096472K av,       0K used, 2096472K free                   67828K cached

After I've done a vacuum , the situation is:
 
 

 12:04pm  up 8 min,  1 user,  load average: 0.22, 0.23, 0.12

78 processes: 76 sleeping, 2 running, 0 zombie, 0 stopped

CPU states:  2.5% user,  1.9% system,  0.0% nice, 95.4% idle

Mem:  1031020K av, 1016580K used,   14440K free,       0K shrd,   18624K buff

Swap: 2096472K av,       0K used, 2096472K free                  833896K cached

As you see the memory used by vacuum isn't released anymore? Anyone know why?
 
My statement is: vacuumdb --analyze dbname
My pg paramaters on postgresql.conf are:
 
#
#       Shared Memory Size
#
shared_buffers = 2048        # 2*max_connections, min 16
max_fsm_relations = 100    # min 10, fsm is free space map
max_fsm_pages = 10000      # min 1000, fsm is free space map
max_locks_per_transaction = 64 # min 10
wal_buffers = 8            # min 4
 
#
#       Non-shared Memory Sizes
#
sort_mem = 512             # min 32
vacuum_mem = 8192          # min 1024
Did anyone know why this happend?

Distinti Saluti
 
Sgarbossa Domenico
X Tecnica S.R.L.
www.xtecnica.com
Tel: 049/9409154 - 049/5970297
Fax: 049/9400288

Reply via email to