Re: bytea or blobs? - Mailing list pgsql-sql

From Igor Shevchenko
Subject Re: bytea or blobs?
Date
Msg-id 200402201442.13869.igor@carcass.ath.cx
Whole thread Raw
In response to Re: bytea or blobs?  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
List 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


pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: pg_restore - don?t restore. Why?
Next
From: mark
Date:
Subject: create function atof?