Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Memory problems with vacuum!!!

Status
Not open for further replies.

sbraaa

Programmer
Oct 7, 2002
3
IT
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top