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 E9961D1EDA0 for ; Fri, 7 May 2004 08:47:00 -0300 (ADT) 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 26317-10 for ; Fri, 7 May 2004 08:46:43 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 5F0F1D1EC3B for ; Fri, 7 May 2004 08:46:40 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i47BkdSx065831 for ; Fri, 7 May 2004 11:46:39 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i47BahLd045548 for pgsql-sql@postgresql.org; Fri, 7 May 2004 11:36:43 GMT X-Abuse-Report: abuse@teranews.com Message-ID: <1a767868f2808ffd48ed4166f1f86c1f@news.teranews.com> Date: Fri, 07 May 2004 11:29:40 GMT Lines: 14 From: Jeff Boes X-Newsgroups: comp.databases.postgresql.sql Subject: Re: not really SQL but I need info on BLOBs Organization: Nexcerpt, Inc. Reply-To: jboes@nexcerpt.com References: <20040505151003.63773.qmail@web41004.mail.yahoo.com> X-Newsreader: Forte Agent 2.0/32.652 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/70 X-Sequence-Number: 17784 In the same vein ... We are at present using BLOBs to store images (but not very many) and generated output (mostly HTML and XML). The data being stored doesn't require BLOB use because of size; it's mostly the binary nature of the data. Lack of satisfaction with the BLOB support (generally difficult to dump and reload the database; strange problems such as OIDs exceeding 2G causing some interface code to break; very difficult to search the BLOB for specific strings) has led us to consider whether we might be better off with a different solution. The one being considered is to convert the BLOBs to BYTEA fields. Does anyone have any experience with this approach? Is there anything in upcoming versions of Pg that would make BLOBs more useful for us?