pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Domenico Sgarbossa <domenico@xtecnica.com>
To: pgsql-performance@postgresql.org
Subject: Problems with vacuum!
Date: Fri, 11 Jun 2004 15:54:44 +0200
Message-ID: <003901c44fbb$a6f02090$70c8007e@xtecnica.it> (raw)

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

view thread (11+ messages)  latest in thread

Message-ID: <003901c44fbb$a6f02090$70c8007e@xtecnica.it>
Permalink:  ../003901c44fbb$a6f02090$70c8007e@xtecnica.it/
Also on:    postgresql.org/message-id/003901c44fbb$a6f02090$70c8007e@xtecnica.it

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: domenico@xtecnica.com
  Subject: Re: Problems with vacuum!
  In-Reply-To: <003901c44fbb$a6f02090$70c8007e@xtecnica.it>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox