Re: Backing up large objects

Поиск
Список
Период
Сортировка
От David Wall
Тема Re: Backing up large objects
Дата
Msg-id 94lb0t$21s0$1@news.tht.net
обсуждение исходный текст
Ответ на Backing up large objects  (Adam Haberlach <adam@newsnipple.com>)
Ответы Re: Backing up large objects
Список 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



В списке pgsql-general по дате отправления:

Предыдущее
От: "Ronnie Esguerra"
Дата:
Сообщение: FW: Postgres-Book from addison-wesley?
Следующее
От: Doug Semig
Дата:
Сообщение: Re: Re: VACUUM and 24/7 database operation