From: Jeff Boes <jboes@nexcerpt.com>
To: pgsql-sql@postgresql.org
Subject: Re: not really SQL but I need info on BLOBs
Date: Fri, 07 May 2004 11:29:40 GMT
Message-ID: <1a767868f2808ffd48ed4166f1f86c1f@news.teranews.com> (raw)
References: <20040505151003.63773.qmail@web41004.mail.yahoo.com>
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?
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jboes@nexcerpt.com
Subject: Re: not really SQL but I need info on BLOBs
In-Reply-To: <1a767868f2808ffd48ed4166f1f86c1f@news.teranews.com>
* 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