Skip site navigation (1) Skip section navigation (2)

Setting vacuum_mem for vacuumdb utility

From: Jeff Boes <jboes(at)qtm(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Setting vacuum_mem for vacuumdb utility
Date: 2004-05-27 16:56:46
Message-ID: a493d97acab9a60c7ca9f5dd568b5e8f@news.teranews.com (view raw or flat)
Thread:
Lists: pgsql-admin
I just discovered that the use of a much larger setting on vacuum_mem 
has a joyous effect on the throughput of VACUUM FULL for some of our 
tables. However, all of my maintenance scripts use "vacuumdb" (the 
command-line utility) instead of psql. How can I set vacuum_mem for the 
duration of the vacuumdb command's execution?



-- 
Jeff Boes                                      vox 269.226.9550 ext 24
Database Engineer                                     fax 269.349.9076
Nexcerpt, Inc.                                 http://www.nexcerpt.com
            ...Nexcerpt... Extend your Expertise

Responses

pgsql-admin by date

Next:From: Moharar, Mausumi (YBUSA-CDR)Date: 2004-05-27 18:14:53
Subject: Problem to run MasterInit for Rserv in Mirroring of Databases
Previous:From: Marty ScholesDate: 2004-05-27 16:45:03
Subject: Re: What is safe to exclude when doing a UFS backup?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group