Skip site navigation (1) Skip section navigation (2)

Re: Purge Oid

From: Bill Moran <wmoran(at)collaborativefusion(dot)com>
To: "Miracapillo Alessandro" <Alessandro(dot)Miracapillo(at)one-ans(dot)it>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Purge Oid
Date: 2008-06-13 10:55:17
Message-ID: 20080613065517.973c42f9.wmoran@collaborativefusion.com (view raw or flat)
Thread:
Lists: pgsql-bugs
In response to "Miracapillo Alessandro" <Alessandro(dot)Miracapillo(at)one-ans(dot)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(at)collaborativefusion(dot)com
Phone: 412-422-3463x4023

In response to

  • Purge Oid at 2008-06-13 09:21:02 from Miracapillo Alessandro

Responses

  • R: Purge Oid at 2008-06-13 11:04:32 from Miracapillo Alessandro

pgsql-bugs by date

Next:From: Miracapillo AlessandroDate: 2008-06-13 11:04:32
Subject: R: Purge Oid
Previous:From: Miracapillo AlessandroDate: 2008-06-13 09:21:02
Subject: Purge Oid

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group