Re: Orphan files - Mailing list pgsql-admin

From Tom Lane
Subject Re: Orphan files
Date
Msg-id 25168.1146199426@sss.pgh.pa.us
Whole thread Raw
In response to Orphan files  (dzung nguyen the <dzungthenguyen@yahoo.com>)
List pgsql-admin
dzung nguyen the <dzungthenguyen@yahoo.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

pgsql-admin by date:

Previous
From: "Ben K."
Date:
Subject: Re: New system recommendations
Next
From: "Wang, Marcus"
Date:
Subject: Re: Regarding start postgresql startservice