Re: Extending varlena

From: David Fetter <david(at)fetter(dot)org>
To: Andrew Chernow <ac(at)esilo(dot)com>
Cc: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Extending varlena
Date: 2008-08-18 22:21:45
Message-ID: 20080818222145.GF7447@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Aug 18, 2008 at 06:09:13PM -0400, Andrew Chernow wrote:
> David Fetter wrote:
>> Folks,
>>
>> As the things stored in databases grow, we're going to start
>> needing to think about database objects that 4 bytes of size can't
>> describe. People are already storing video in lo and bytea fields.
>> To date, the sizes of media files have never trended downward.
>
> I always find these requests puzzling. Is it really useful to store
> the data for a jpeg, video file or a 10GB tar ball in a database
> column?

It is if you need transaction semantics. Think medical records, etc.

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Chernow 2008-08-18 22:35:32 Re: Extending varlena
Previous Message Alvaro Herrera 2008-08-18 22:11:36 Re: pgbench duration option