X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 20C6BD791E for ; Fri, 2 Sep 2005 16:16:30 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 98343-05 for ; Fri, 2 Sep 2005 19:16:25 +0000 (GMT) Received: from webmail2.sd.dreamhost.com (webmail2.sd.dreamhost.com [66.33.201.157]) by svr1.postgresql.org (Postfix) with ESMTP id 7F29FD78E3 for ; Fri, 2 Sep 2005 16:16:24 -0300 (ADT) Received: from webmail.oss.minimetria.com (localhost [127.0.0.1]) by webmail2.sd.dreamhost.com (Postfix) with ESMTP id 4F973DC791 for ; Fri, 2 Sep 2005 12:15:46 -0700 (PDT) Received: from 70.34.104.163 (SquirrelMail authenticated user leon@oss.minimetria.com) by webmail.oss.minimetria.com with HTTP; Fri, 2 Sep 2005 12:15:46 -0700 (PDT) Message-ID: <42165.70.34.104.163.1125688546.squirrel@webmail.oss.minimetria.com> Date: Fri, 2 Sep 2005 12:15:46 -0700 (PDT) Subject: Recommendation on bytea or blob for binary data like images From: leon@oss.minimetria.com To: pgsql-sql@postgresql.org User-Agent: SquirrelMail/1.4.4 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.178 required=5 tests=[NO_REAL_NAME=0.178] X-Spam-Level: X-Archive-Number: 200509/17 X-Sequence-Number: 22564 Hi, I'd like to know what the official recommendation is on which binary datatype to use for common small-binary size use. I'm working with the Open For Business (www.ofbiz.org) framework, which by default maps binary data, such as shipping label images, into OID field types. In general, the data is far less than a gigabyte in size. Is it strongly recommended by the postgresql community to store things like this in bytea format as of 8.0? Thanks, Leon Torres leon@oss.minimetria.com Open Source Strategies http://opensourcestrategies.com