Re: Purge Oid

Поиск
Список
Период
Сортировка
От Bill Moran
Тема Re: Purge Oid
Дата
Msg-id 20080613065517.973c42f9.wmoran@collaborativefusion.com
обсуждение исходный текст
Ответ на Purge Oid  ("Miracapillo Alessandro" <Alessandro.Miracapillo@one-ans.it>)
Ответы R: Purge Oid
Список 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 по дате отправления:

Предыдущее
От: "Miracapillo Alessandro"
Дата:
Сообщение: Purge Oid
Следующее
От: "Miracapillo Alessandro"
Дата:
Сообщение: R: Purge Oid