pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dana Hudes <dhudes@tcp-ip.info>
To: Richard Huxton <dev@archonet.com>
Cc: Dana Hudes <dhudes@tcp-ip.info>
Cc: pgsql-sql@postgresql.org
Subject: Re: bytea or blobs?
Date: Wed, 18 Feb 2004 10:17:39 -0500 (EST)
Message-ID: <Pine.LNX.4.58.0402181015520.729@screamer.tcp-ip.info> (raw)
In-Reply-To: <200402180944.42239.dev@archonet.com>
References: <E8D7DFA4-5C92-11D8-B55E-0003938366A4@ntlworld.com>
	<200402180914.29318.sad@bankir.ru>
	<Pine.LNX.4.58.0402180116000.729@screamer.tcp-ip.info>
	<200402180944.42239.dev@archonet.com>

How can one measure the result of the compression -- can I see this in
some table or with some pgsql command?
At what threshold does it take place, I think its 8192?
The nasty bit is not one picture of 100kb.
Its 20 pictures of 5kb.

On Wed, 18 Feb 2004, Richard Huxton wrote:

> On Wednesday 18 February 2004 06:44, Dana Hudes wrote:
> >
> > At least with base64 I have ample libraries and can convert my data
> > before sending to sql or after receiving from sql. It becomes my
> > application's issue. Mind, this bloats the data considerably.
> > escape is less bloat but I have to recreate the encode/decode in my app,
> > so far as I see.
> 
> Less bloat than you might expect - large values are TOASTed and compressed. 
> I'm guessing a lot of your redundancy will be eliminated.
> 
> Having said that, bytea's purpose in life is to store your binary data.
> 
> 



view thread (14+ messages)  latest in thread

Message-ID: <Pine.LNX.4.58.0402181015520.729@screamer.tcp-ip.info>
Permalink:  ../Pine.LNX.4.58.0402181015520.729@screamer.tcp-ip.info/
Also on:    postgresql.org/message-id/Pine.LNX.4.58.0402181015520.729@screamer.tcp-ip.info

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: dhudes@tcp-ip.info, dev@archonet.com
  Subject: Re: bytea or blobs?
  In-Reply-To: <Pine.LNX.4.58.0402181015520.729@screamer.tcp-ip.info>
  References: <E8D7DFA4-5C92-11D8-B55E-0003938366A4@ntlworld.com> <200402180914.29318.sad@bankir.ru> <Pine.LNX.4.58.0402180116000.729@screamer.tcp-ip.info> <200402180944.42239.dev@archonet.com> <Pine.LNX.4.58.0402181015520.729@screamer.tcp-ip.info>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox