Re: BUG #12050: Orphaned base files - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #12050: Orphaned base files
Date
Msg-id 929.1425666849@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #12050: Orphaned base files  (Jamie Koceniak <jkoceniak@mediamath.com>)
List pgsql-bugs
Jamie Koceniak <jkoceniak@mediamath.com> writes:
> If I don't remove the orphaned files, is there any change that Postgres could use the same file node (oid)  again?

> For example, say file node 2602351127 doesn't exist anywhere in pg_class, could Postgres use that same file node id
again?
> What would happen in that case?

It will not overwrite an existing file when selecting a new relfilenode.

            regards, tom lane

pgsql-bugs by date:

Previous
From: pgriboval@yahoo.fr
Date:
Subject: BUG #12830: postgres-9.4 upgrade is missing PGPORT
Next
From: Kevin Grittner
Date:
Subject: Re: BUG #12834: Avoiding Disk Control Writes for better Laptop / SSD compatibility. pgstats