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

R: Purge Oid

From: "Miracapillo Alessandro" <Alessandro(dot)Miracapillo(at)one-ans(dot)it>
To: "Bill Moran" <wmoran(at)collaborativefusion(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: R: Purge Oid
Date: 2008-06-13 11:04:32
Message-ID: 1A29A61B8C7BAE419940B34E2E04F4C0032C76DC@BESTWO.corp.dom (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-bugs
Thanks for response,

the process that do VACCUM FULL was in hang but I see it after my mail

thanks for your interest

best regards

Alessandro Miracapillo




-----Messaggio originale-----
Da: Bill Moran [mailto:wmoran(at)collaborativefusion(dot)com] 
Inviato: venerdì 13 giugno 2008 12.55
A: Miracapillo Alessandro
Cc: pgsql-bugs(at)postgresql(dot)org
Oggetto: Re: [BUGS] Purge Oid

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


Internet Email Confidentiality Footer
-----------------------------------------------------------------------------------------------------
La presente comunicazione, con le informazioni in essa contenute e ogni documento o file allegato, e' rivolta unicamente alla/e persona/e cui e' indirizzata ed alle altre da questa autorizzata/e a riceverla. Se non siete i destinatari/autorizzati siete avvisati che qualsiasi azione, copia, comunicazione, divulgazione o simili basate sul contenuto di tali informazioni e' vietata e potrebbe essere contro la legge (art. 616 C.P., D.Lgs n. 196/2003 Codice in materia di protezione dei dati personali). Se avete ricevuto questa comunicazione per errore, vi preghiamo di darne immediata notizia al mittente e di distruggere il messaggio originale e ogni file allegato senza farne copia alcuna o riprodurne in alcun modo il contenuto. 

This e-mail and its attachments are intended for the addressee(s) only and are confidential and/or may contain legally privileged information. If you have received this message by mistake or are not one of the addressees above, you may take no action based on it, and you may not copy or show it to anyone; please reply to this e-mail and point out the error which has occurred. 
-----------------------------------------------------------------------------------------------------


In response to

pgsql-bugs by date

Next:From: Lawrence CohanDate: 2008-06-13 14:34:04
Subject: BUG #4238: pg_class.relhasindex not updated by vacuum
Previous:From: Bill MoranDate: 2008-06-13 10:55:17
Subject: Re: Purge Oid

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