Re: Storing images in PostgreSQL databases (again) - Mailing list pgsql-general

From Alexander Staubo
Subject Re: Storing images in PostgreSQL databases (again)
Date
Msg-id AABB1E6C-D5C6-4EEE-91AB-FCD4029DFFC8@purefiction.net
Whole thread Raw
In response to Re: Storing images in PostgreSQL databases (again)  (Jean-Christophe Roux <jcxxr@yahoo.com>)
List 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.

pgsql-general by date:

Previous
From: Jean-Christophe Roux
Date:
Subject: Re: Storing images in PostgreSQL databases (again)
Next
From: "Leonel Nunez"
Date:
Subject: Re: Storing images in PostgreSQL databases (again)