Re: Unexpectedly high disk space usage RESOLVED (Manual reindex/vacuum)

From: Greg Williamson <gwilliamson39(at)yahoo(dot)com>
To:
Cc: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Unexpectedly high disk space usage RESOLVED (Manual reindex/vacuum)
Date: 2012-11-10 02:45:45
Message-ID: 1352515545.72495.YahooMailNeo@web125901.mail.ne1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Scott -- 

<...>

>To tune autovacuum with 50 databases, start by dropping nap time to
>something much lower, like 10s.  Then if you need to, drop cost delay
>until you get to 0.  If you get to 0 and it's still not hitting your
>IO too hard, but not keeping up, then increase cost limit.  If you get
>to something in the 5000 to 10000 range, and its still not keeping up
>then start bumping the thread count
>

Thanks for outlining a strategy on this -- useful advice.

Greg Williamson

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tefft, Michael J 2012-11-10 14:03:01 "could not write to output file: Permission denied" during pg_dump
Previous Message Chris Angelico 2012-11-10 02:17:18 PG defaults and performance (was Re: Unexpectedly high disk space usage RESOLVED (Manual reindex/vacuum))