HELP? Postgres filling up disk

From: HT Levine <htlevine(at)ebates(dot)com>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: HELP? Postgres filling up disk
Date: 2002-12-19 01:54:41
Message-ID: A0F24737FCB34F489EC955D143BDD851018EFEE2@exchange-sf1.corp.ebates.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I posted over the weekend about this issue under the subject of "VACUUM"
but the replies I got did not help. We have several large tables which seem
to be taking 4 times as much disk space as they should?

Let me give a little background:

Every night, we do a pg_dump of our production DB and a pg_restore of this
dumb into a standby DB. What I notice is the size of the standby DB is MORE
THAN HALF the size of production.

For example, here is the oid2name dump of a table called users on
PRODUCTION:
$ oid2name -d EBPRD1 -t users
Oid of table users from database "EBPRD1":
_______________________________
17260 = users
$ ls -l 17260*
-rw------- 1 postgres postgres 1073741824 Dec 18 17:48 17260
-rw------- 1 postgres postgres 1073741824 Dec 18 17:48 17260.1
-rw------- 1 postgres postgres 1073741824 Dec 18 17:48 17260.2
-rw------- 1 postgres postgres 165445632 Dec 18 17:51 17260.3


but the same table on the standby DB yields this:

$ oid2name -d EBPRDS1 -t users
Oid of table users from database "EBPRDS1":
_______________________________
3828262123 = users
$ ls -l 3828262123
-rw------- 1 postgres postgres 1073741824 Dec 18 16:55 3828262123

I tried a full VACUUM of the users table on production, but I didn't get any
disk space back. I also looked thru all oids and there are no pg_toast
files of significance. I am on postgres 7.2 How do I reclaim this disk
space?

Any help would be GREATLY Appreciated!

thanks in advance

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-12-19 05:16:22 Re: HELP? Postgres filling up disk
Previous Message Tom Lane 2002-12-18 19:16:15 Re: Strange behaviour ( function cachable )