Re: Bytea/Large Objects/external files best practices

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Bytea/Large Objects/external files best practices
Date: 2004-01-15 17:35:06
Message-ID: 20040115183506.A2620@hermes.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I think those best practices threads are a treat to follow (might even
> consider archiving some of them in a sort of best-practices faq), so
Please do.

> 1) Bytea column. Seems the cleanest solution, but
> *) I seem to remember reading in a discussion in the [hackers] list
> that the TOAST column substring operation had been optimized so that
> partial fetches might be viable.
Works. Not sure what happens on the wire, though.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel E. Fisher 2004-01-15 17:47:53 Re: Errors after power failure
Previous Message Marco Lazzeri 2004-01-15 17:23:47 CASE SELECT syntax