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

Re: Disk Usage Problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fahey <mfahey(at)winklerpartners(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Disk Usage Problem
Date: 2005-08-31 04:44:12
Message-ID: 27988.1125463452@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Michael Fahey <mfahey(at)winklerpartners(dot)com> writes:
> My database cluster at 22 GB is outgrowing the 30 GB partition I set 
> aside for it.

> I periodically dump the cluster to a development server, but when it is 
> loaded onto the development server, the cluster takes up just 145MB.

> I'm using 7.4.7-6sarge1 . I vacuum nightly and do a full vacuum weekly, 
> but this doesn't seem to have any effect on size.

It's clear that you aren't vacuuming *nearly* enough for your workload.
Think about vacuuming hourly.  Check your FSM settings.

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: Jeff FrostDate: 2005-08-31 05:33:22
Subject: auto vacuum settings
Previous:From: Michael FaheyDate: 2005-08-31 03:52:17
Subject: Disk Usage Problem

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