Re: no space left on device - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: no space left on device
Date
Msg-id 20040109214647.GA18959@dcc.uchile.cl
Whole thread Raw
In response to Re: no space left on device  ("Aurangzeb M. Agha" <ama-list@mltp.com>)
List pgsql-general
On Fri, Jan 09, 2004 at 01:11:51PM -0800, Aurangzeb M. Agha wrote:
> I've not run a vacuum in quite some time, and that's because I've only
> been doing reads from this DB.  I was under the impression that I should
> run vacuum when tables are heavily modified:
>
> http://www.postgresql.org/docs/aw_pgsql_book/node110.html

Another reason to vacuum is that the pg_clog files are deleted if they
are no longer needed.  So if you had vacuumed, there would be less files
there (I'm not sure if this was the case on 7.1 though).

Maybe in the meantime you could move one of the pg_xlog files to another
filesystem and make a symlink to the correct position.  That should given
you some breathing room.  Vacuum right after that.

Also keep in mind that deleted files that are kept open by running
processes do not release the occupied space ... see if you have some
process with an open file on that filesystem which is no longer present
(some clever usage of fuser and ps should give you that info)

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"We are who we choose to be", sang the goldfinch
when the sun is high (Sandman)

pgsql-general by date:

Previous
From: "Aurangzeb M. Agha"
Date:
Subject: Re: no space left on device
Next
From: Frank van Vugt
Date:
Subject: Why does this use of accents in psql fail for a Unicode database?