Re: [RFC] Comments on PostPic project - Repost

Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)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