I've notice that when vacuumdb runs nightly it uses all the available memory but when process ends it doesn't release the memory so next processes had to swap on disk.
My statement is:
vacuumdb --analyze dbname
when i first boot up the linux box, this is the situation provided by TOP:
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
then after the vacuum , the situation is that:
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 i've got 2GB of ram but after the running of vacuum all the memory isn't available anymore?
My postmaster parameters 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
the version of postgreSQL is 7.2
Did anyone notice that?
Do I need tu upgrade my postreSQL version with next versions released? (such as 7.3 ot 7.4?)
Any suggestions are very appreciate! thanks
My statement is:
vacuumdb --analyze dbname
when i first boot up the linux box, this is the situation provided by TOP:
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
then after the vacuum , the situation is that:
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 i've got 2GB of ram but after the running of vacuum all the memory isn't available anymore?
My postmaster parameters 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
the version of postgreSQL is 7.2
Did anyone notice that?
Do I need tu upgrade my postreSQL version with next versions released? (such as 7.3 ot 7.4?)
Any suggestions are very appreciate! thanks