X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 25AA3D1DD99 for ; Wed, 18 Feb 2004 15:18:56 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 51292-07 for ; Wed, 18 Feb 2004 11:18:48 -0400 (AST) Received: from screamer.tcp-ip.info (screamer.tcp-ip.info [68.167.18.162]) by svr1.postgresql.org (Postfix) with ESMTP id 27B4AD1CCCC for ; Wed, 18 Feb 2004 11:18:39 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by screamer.tcp-ip.info (8.12.10/8.12.10/SuSE Linux 0.7) with ESMTP id i1IFHdMP009130; Wed, 18 Feb 2004 10:17:39 -0500 Date: Wed, 18 Feb 2004 10:17:39 -0500 (EST) From: Dana Hudes X-X-Sender: dhudes@screamer.tcp-ip.info To: Richard Huxton Cc: Dana Hudes , pgsql-sql@postgresql.org Subject: Re: bytea or blobs? In-Reply-To: <200402180944.42239.dev@archonet.com> Message-ID: References: <200402180914.29318.sad@bankir.ru> <200402180944.42239.dev@archonet.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/250 X-Sequence-Number: 16940 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. > >