Re: bytea or blobs?

From: Igor Shevchenko <igor(at)carcass(dot)ath(dot)cx>
To: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: bytea or blobs?
Date: 2004-02-20 12:42:13
Message-ID: 200402201442.13869.igor@carcass.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wednesday 18 February 2004 09:18, you wrote:
> Maybe if bandwidth is a restriction the base64 solution
> saves some bandwith, since base64 file is ~ 1.3 times larger
> than the original, whereas the escaped octal representation
> will be ~ 4 times larger.

If you use libpq's v3 protocol with binary format (PostgreSQL 7.4+), the
overhead is minimal both ways.

--
Best regards,
Igor Shevchenko

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Mark Tabash 2004-02-20 14:01:21 create function atof?
Previous Message Andrew Sullivan 2004-02-20 12:14:42 Re: pg_restore - don?t restore. Why?