Given your data set is small so a dump/restore cycle is painless, you
should also consider upgrading to the latest stable release.
I agree with Raghu that you need to vacuum your database periodically
to keep it's footprint under control, but rather than doing the VACUUM
commands via scheduled activity you should use the auto vacuum daemon
unless you have specific needs. You probably do need to do the first
vacuum by hand with no users connected (or do a dump/restore cycle which
is perhaps quicker with a system as bloated as yours).
http://www.postgresql.org/docs/8.2/static/routine-vacuuming.html#AUTOVACUUM
Given you missed the need to vacuum I would read the whole routine
maintenance section in case there are other activities that you should
be performing to keep your data safe and available:
http://www.postgresql.org/docs/8.2/static/maintenance.html
Hope this helps,
Robin
On Tue, 10 Apr 2012 11:44:08 +0530, raghu ram wrote:
On Tue, Apr 10, 2012 at 11:21 AM, Kiruba suthan wrote:
Could you help me how to clean up DB Cluster folder and reclaim disk
space please? And please give me some insight into how data is
organized in DB Cluster and what should I do to avoid this happening
again?
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin