| From: | David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com> |
|---|---|
| To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
| Cc: | Dennis Gearon <gearond(at)fireserve(dot)net>, pgsql General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: bytea |
| Date: | 2004-05-12 15:28:03 |
| Message-ID: | 40A24283.7010100@zara.6.isreserved.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
scott.marlowe wrote:
> And yes, toasting is fully automatic. Just insert a large
> text/varchar/bytea field and the database does the rest. which is why
> they are generally recommended over using large objects, which require
> specialized handling.
They are not always recommended though. The manual clearly states that
bytea/text's drawback is huge memory requirement (esp. for large
data/long text) and lack of chunk processing. Hopefully this will be
addressed in the future.
--
dave
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2004-05-12 15:37:51 | Re: LISTEN/NOTIFY with JDBC |
| Previous Message | Fred Fung | 2004-05-12 15:27:19 | dbmirror |