Re: Storing images in PostgreSQL databases (again)

From: Alexander Staubo <alex(at)purefiction(dot)net>
To: Jean-Christophe Roux <jcxxr(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Storing images in PostgreSQL databases (again)
Date: 2006-10-05 23:35:04
Message-ID: AABB1E6C-D5C6-4EEE-91AB-FCD4029DFFC8@purefiction.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Oct 6, 2006, at 01:29 , Jean-Christophe Roux wrote:

> By the way, is it practical to set a bytea column (containing
> pictures) as primary key? That would severely slow down many
> operations I guess.

Why would you? It's possible, but completely impractical, since image
data typically exceeds the index page size. Moreover, are you really
going to retrieve an image row by its image data?

Alexander.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Christophe Roux 2006-10-05 23:54:32 Re: Storing images in PostgreSQL databases (again)
Previous Message Jean-Christophe Roux 2006-10-05 23:29:01 Re: Storing images in PostgreSQL databases (again)