Re: [RFC] Comments on PostPic project - Repost

Поиск
Список
Период
Сортировка
От Domenico Rotiroti
Тема Re: [RFC] Comments on PostPic project - Repost
Дата
Msg-id 11f931f91003160634i7b426362s7e7081912ac2afc8@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [RFC] Comments on PostPic project - Repost  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Список pgsql-hackers

Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
There's the "vacuumlo" contrib module that removes orphaned
large objects.

 
Thanks for pointing out. Vacuumlo looks at oid and lo columns to find orphaned lobs, but the idea could be easily adapted/extended to looks for image columns.
 
Why don't you use bytea instead of large objects in the database?
That way you won't have to worry about orphaned large objects,
and you don't have to convert to bytea upon retrieval.

When I started coding PostPic I knew little about PostgreSQL's large objects implementation, and was used to more 'traditional' BLOB types found in other databases.

Regards,
Domenico

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: An idle thought
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Bug in 9.0Alpha4