From: | "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Help on maintaining pgsql/data folder size |
Date: | 2005-03-07 07:08:14 |
Message-ID: | 77ED2BF75D59D1439F90412CC5B109741A76E8AA@ie10-sahara.hiso.honeywell.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi all,
I am using PostgreSQL 7.4.3. The problem I am facing is that the size of
pgsql/data folder keeps increasing and at a point the it takes up all the
disk space and it freezes the system. The pg_xlog and the pg_clog folders
are taking up most of the disk space. In the documentation, it says that I
have to move the pg_xlog folder to some other location and create a symbolic
link to that path from the original path. But the problem is for our
application, we are using a 512 MB compact flash and there is no
harddisk....so I need to check the database folder size somehow. Could
anyone help me out in this regard.
Between in order to recover the disk space, I am using a script which
vacuums the database regularly.
Thanks in advance for all your valuable inputs.
Regards,
Pradeep
From | Date | Subject | |
---|---|---|---|
Next Message | Miroslav Šulc | 2005-03-07 07:16:22 | Re: how to install pg 8 in windows fat32 partition |
Previous Message | Richard Sitompul | 2005-03-07 04:16:02 | Re: how to install pg 8 in windows fat32 partition |