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

Re: Disk space taken

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Slavisa Garic <sgaric(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Disk space taken
Date: 2006-07-18 12:34:05
Message-ID: 20060718123405.80184.qmail@web31808.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
> I've run into an interesting situation (interesting for me at least :-)). I
> have a table that takes up about a 1GB of disk space but has no entries in
> it. I asume this is old stuff data that hasn't been cleaned up properly but
> I have no idea how to get rid of it.
> 
> I'll quickly show few things I've done to get the information I have:

I believe that only vacuum full returns disk spaces.  Also, if there are any indexs they could be
using disk space also.

http://www.postgresql.org/docs/8.1/interactive/sql-reindex.html
http://www.postgresql.org/docs/8.1/interactive/sql-vacuum.html

Regards,

Richard Broersma Jr.



In response to

Responses

pgsql-novice by date

Next:From: Slavisa GaricDate: 2006-07-18 12:55:39
Subject: Re: Disk space taken
Previous:From: Slavisa GaricDate: 2006-07-18 10:22:35
Subject: Disk space taken

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