OID type creates files that don't go away - Mailing list pgsql-admin

From David Wall
Subject OID type creates files that don't go away
Date
Msg-id 94lb6j$21ta$1@news.tht.net
Whole thread Raw
Responses Re: OID type creates files that don't go away  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-admin
I've created several blobs using the OID type.  I note that the database
stores the "oid" number that represents two files on disk, such as xinv21281
and xinx21281 with the oid in the database showing up as 21281 via a SELECT.

But, I deleted a row that contained this oid, and the two 'x' files are
still on disk.  I then ran a VACUUM, saw that 1 record was reaped, but the
two 'x' files remain.  Are these 'x' files going to be reused in some
manner, or is this a bug that keeps them around despite the fact that the
database row for it has been removed?

David



pgsql-admin by date:

Previous
From: Robert.Farrugia@go.com.mt
Date:
Subject: Temporary files directory
Next
From: Stefan Huber
Date:
Subject: Re: Temporary files directory