Try
Home   >   mailing lists

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

From Jean-Christophe Roux
Subject Re: Storing images in PostgreSQL databases (again)
Date
Msg-id [email protected]
Whole thread Raw
In response to Storing images in PostgreSQL databases (again)  (TIJod <[email protected]>)
Responses Re: Storing images in PostgreSQL databases (again)
Re: Storing images in PostgreSQL databases (again)
List pgsql-general
Tree view
Why would I set a bytea column (containing picures) as a primary key? Because I want to be sure that the same image is inserted only once (that requirement comes from a real project) and using a primary key for that purpose makes sense to me.
Am I going to retrieve an image row by its image data? I would certainly like! For instance, I would like to get the pictures whose main color is green (requirement from a real project), and a
select * from images where main_color(image) = 'green' would be nice.
JCR


----- Original Message ----
From: Alexander Staubo <[email protected]>
To: Jean-Christophe Roux <[email protected]>
Cc: [email protected]
Sent: Thursday, October 5, 2006 7:35:04 PM
Subject: Re: [GENERAL] Storing images in PostgreSQL databases (again)

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.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [email protected] so that your
       message can get through to the mailing list cleanly


pgsql-general by date:

Previous
From: andy rost
Date:
Subject: URGENT - startup process (PID 29541) was terminated by signal 6
Next
From: [email protected]
Date:
Subject: Re: Installation on mandriva 2006