Re: Backing up large objects

From: "David Wall" <d(dot)wall(at)computer(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Backing up large objects
Date: 2001-01-24 01:27:22
Message-ID: 94lb0t$21s0$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sanjay Arora 2001-01-24 01:32:58 Re: VACUUM and 24/7 database operation
Previous Message Tiger Technologies 2001-01-24 01:13:57 Re: VACUUM and 24/7 database operation