On Jan 8, 2008, at 9:13 AM, Scott Marlowe wrote:
> On Jan 8, 2008 9:01 AM, Harald Armin Massa
> <haraldarminmassa@gmail.com> wrote:
>>> Not likely to change in the future, no. Slony uses triggers to
>>> manage the
>>> changed rows. We can't fire triggers on large object events, so
>>> there's no
>>> way for Slony to know what happened.
>>
>> that leads me to a question I often wanted to ask:
>>
>> is there any reason to create NEW PostgreSQL databases using Large
>> Objects, now that there is bytea and TOAST? (besides of legacy needs)
>>
>> as much as I read, they take special care in dump/restore; force the
>> use of some special APIs on creating, do not work with Slony ....
>
> The primary advantage of large objects is that you can read like byte
> by byte, like a file.
Also, with bytea (and any other varying length data type) there is
still a limit of 1G via TOASTing. Large Objects will get you up to
2G for one field.
Erik Jones
DBA | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com