Re: Purge Oid - Mailing list pgsql-bugs

From Bill Moran
Subject Re: Purge Oid
Date
Msg-id 20080613065517.973c42f9.wmoran@collaborativefusion.com
Whole thread Raw
In response to Purge Oid  ("Miracapillo Alessandro" <Alessandro.Miracapillo@one-ans.it>)
Responses R: Purge Oid
List pgsql-bugs
In response to "Miracapillo Alessandro" <Alessandro.Miracapillo@one-ans.it>:
>
> Db_data FS is full because file oid are too large, how I can delete old
> OID file without to risk to damage oid relation database

Are you vacuuming on a regular basis?  If not, you may need to vacuum
full to get things back under control.  If it's really bad, you may
be better off doing a dump/restore as it may be considerably faster.

Are you sure your database hasn't legitimately grown too large for
your disks?

--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023

pgsql-bugs by date:

Previous
From: "Miracapillo Alessandro"
Date:
Subject: Purge Oid
Next
From: "Miracapillo Alessandro"
Date:
Subject: R: Purge Oid