Re: bytea or large objects?

Joshua D. Drake wrote:
>
>> I've just re-written our Whitebeam code to drop large-objects in
>> favour of BYTEA fields.
>>
>> All the old problems of large objects in backups exist, but the killer
>> for us was that none of the current replication systems, at least that
>> I could find, would replicate large objects. This became a mandatory
>> requirements for us.
>
> Mammoth Replicator has always replicated Large Objects. The only
> "backup" issue to large objects is that you have to pass a separate flag
> and use the custom or tar format to dump them.
>
> Bytea has its own issues mostly based around memory usage.
>
> I am not saying you should or shouldn't switch as it really depends on
> your needs but the information above just isn't quite accurate.
>
> Sincerely,
>
> Joshua D. Drake
>
I should have added that my search was limited to open source/free replication
systems.

>
>>
>> I'd have to have a *very* good reason to use large objects over BYTEA
>> now.
>>
>> Pete
>> --
>> http://www.whitebeam.org
>> http://www.yellowhawk.co.uk
>> -----
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 5: don't forget to increase your free space map settings
>
>