Re: Storing images in PostgreSQL databases (again)

Поиск
Список
Период
Сортировка
От Alexander Staubo
Тема Re: Storing images in PostgreSQL databases (again)
Дата
Msg-id AABB1E6C-D5C6-4EEE-91AB-FCD4029DFFC8@purefiction.net
обсуждение исходный текст
Ответ на Re: Storing images in PostgreSQL databases (again)  (Jean-Christophe Roux <jcxxr@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Jean-Christophe Roux
Дата:
Сообщение: Re: Storing images in PostgreSQL databases (again)
Следующее
От: "Leonel Nunez"
Дата:
Сообщение: Re: Storing images in PostgreSQL databases (again)