Postgres Pro
Downloads
Home   >   mailing lists

Setting vacuum_mem for vacuumdb utility - Mailing list pgsql-admin

From Jeff Boes
Subject Setting vacuum_mem for vacuumdb utility
Date
Msg-id a493d97acab9a60c7ca9f5dd568b5e8f@news.teranews.com
Whole thread Raw
Responses Re: Setting vacuum_mem for vacuumdb utility  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: "Frank Smith"
Date:
Subject: Performance Problem
Next
From: "Ivaylo Mutafchiev"
Date:
Subject: Re: [Cross-post] initdb failed on Windows 2003 Advanced Server