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: | 43152971.1030508@winklerpartners.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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.
TIA
Michael
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-08-31 04:44:12 | Re: Disk Usage Problem |
Previous Message | Ben Mitchell | 2005-08-31 03:41:07 | Backup / Restore help |