pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Litao Wu <litaowu@yahoo.com>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: vacuum_mem
Date: Thu, 8 Jul 2004 11:03:43 -0700 (PDT)
Message-ID: <20040708180343.88032.qmail@web13121.mail.yahoo.com> (raw)
In-Reply-To: <1089305420.5999.208.camel@jester>

Hi,

I tested vacuum_mem setting under a 
4CPU and 4G RAM machine. I am the only person 
on that machine.

The table:
         tablename         | size_kb |   reltuples
---------------------------+-------------------------
 big_t                     | 2048392 |   7.51515e+06

Case 1:
1. vacuum full big_t;
2. begin;
   update big_t set email = lpad('a', 255, 'b');
   rollback;
3. set vacuum_mem=655360; -- 640M
4. vacuum big_t;
It takes 1415,375 ms
Also from top, the max SIZE is 615M while 
SHARE is always 566M

  PID USER     PRI  NI  SIZE  RSS SHARE STAT %CPU %MEM
  TIME COMMAND
5914 postgres  16   0   615M 615M  566M D     7.5 15.8
 21:21 postgres: postgres mydb xxx.xxx.xxx.xxx:34361
VACUUM

Case 2:
1. vacuum full big_t;
2. begin;
   update big_t set email = lpad('a', 255, 'b');
   rollback;
3. set vacuum_mem=65536; -- 64M
4. vacuum big_t;
It takes 1297,798 ms
Also from top, the max SIZE is 615M while 
SHARE is always 566M

  PID USER     PRI  NI  SIZE  RSS SHARE STAT %CPU %MEM
  TIME COMMAND
 3613 postgres  15   0  615M 615M  566M D    17.1 15.8
  9:04 postgres: postgres mydb xxx.xxx.xxx.xxx:34365
VACUUM

It seems vacuum_mem does not have performance 
effect at all.

In reality, we vaccum nightly and I want to find out 
which vacuum_mem value is the 
best to short vacuum time.

Any thoughts?

Thanks,


		
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail 



view thread (2+ messages)  latest in thread

Message-ID: <20040708180343.88032.qmail@web13121.mail.yahoo.com>
Permalink:  ../20040708180343.88032.qmail@web13121.mail.yahoo.com/
Also on:    postgresql.org/message-id/20040708180343.88032.qmail@web13121.mail.yahoo.com

 · 

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: litaowu@yahoo.com
  Subject: Re: vacuum_mem
  In-Reply-To: <20040708180343.88032.qmail@web13121.mail.yahoo.com>

* 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