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

Disk Usage Problem

From: Michael Fahey <mfahey(at)winklerpartners(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Disk Usage Problem
Date: 2005-08-31 03:52:17
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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 use temporary tables fairly extensively in a key part of the application.

Here are the biggest tables in the production system:

             relname             | relfilenode | relpages
 pg_attribute_relid_attnam_index |       16609 |  2519264
 pg_attribute_relid_attnum_index |       16610 |    98014
 pg_class_relname_nsp_index      |       16614 |    25220

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.




pgsql-admin by date

Next:From: Tom LaneDate: 2005-08-31 04:44:12
Subject: Re: Disk Usage Problem
Previous:From: Ben MitchellDate: 2005-08-31 03:41:07
Subject: Backup / Restore help

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