Re: Disk space taken - Mailing list pgsql-novice

From Richard Broersma Jr
Subject Re: Disk space taken
Date
Msg-id 20060718123405.80184.qmail@web31808.mail.mud.yahoo.com
Whole thread Raw
In response to Disk space taken  ("Slavisa Garic" <sgaric@gmail.com>)
List 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.



pgsql-novice by date:

Previous
From: kmh496
Date:
Subject: why is scan not using index?
Next
From: Tom Lane
Date:
Subject: Re: why is scan not using index?