Re: Orphan files

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: dzung nguyen the <dzungthenguyen(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Orphan files
Date: 2006-04-28 04:43:46
Message-ID: 25168.1146199426@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

dzung nguyen the <dzungthenguyen(at)yahoo(dot)com> writes:
> Our database files are becoming bigger and bigger.
> We checked OID with filenodes and found some filenodes
> that don't have a corresponding OID.

OID? Or relfilenode? Please read
http://www.postgresql.org/docs/8.1/static/storage.html
pretty darn carefully before you go around deleting files
that you don't know the purpose of.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message platonovvp 2006-04-28 06:16:01 connection refused 274D/10061
Previous Message Ben K. 2006-04-28 03:18:55 Re: New system recommendations