Re: Unexpectedly high disk space usage

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lists <lists(at)benjamindsmith(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unexpectedly high disk space usage
Date: 2012-11-09 01:12:09
Message-ID: 25229.1352423529@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Lists <lists(at)benjamindsmith(dot)com> writes:
> Even so, if I felt the need to keep autovacuum off, what would I need to
> run regularly in order to keep things neat and tidy under the hood?
> Would a simple "vacuum" within each database suffice? Should I be logged
> in as the database owner or as an administrative user?

A plain "vacuum" (or probably better, "vacuum analyze") done as
superuser will suffice, as long as you do it often enough.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tianyin Xu 2012-11-09 01:37:22 Re: Does PostgreSQL have complete functional test cases?
Previous Message Lists 2012-11-09 01:05:37 Re: Unexpectedly high disk space usage