Re: Large binary data [was: contrib: hack for psycopg2 performance]

On Wed, May 12, 2010 at 02:12:20PM +0100, Daniele Varrazzo wrote:

> > Not really (beyond the one the OP posted). Common
> > (PostgreSQL) wisdom holds that it is advantageous when
> > dealing with significant amounts of truly binary data (such
> > as bytea) - which I am (medical documents).
> 
> Aren't large objects more suitable to deal with them?

It much depends. You wanted bytea if you wanted
transactional control. That has been improving somewhat
recently with PG 9.0.

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