question on new psql datatype

Поиск
Список
Период
Сортировка
Искать
От
Yu Pan
Тема
question on new psql datatype
Дата
Msg-id
1106523284.41f4349481672@webmail.nmsu.edu
Список
Дерево обсуждения
question on new psql datatype Yu Pan <yupan@nmsu.edu>
Re: question on new psql datatype Alvaro Herrera <alvherre@dcc.uchile.cl>
Re: question on new psql datatype Michelle Konzack <linux4michelle@freenet.de>
I am developing a new "image" datatype in postgres which contains a binary 
field for storing image data and some other fields for additional information 
about the image, like size, resolution, etc. I was hoping that the clients can 
saving their time by directly retrieving these information from the fields 
without retrieving the whole image, that is, the time for reading these fields 
should be constant with respect to the image size. However, the result shows 
that the time for direct retrieving of information from the fields of an image 
datatype is still increasing with the size of the image. My explanation is 
that in order to read the fields of a image datatype, the whole struct would 
still need to be loaded into memory, which includes the binary field 
containing the actual image data. Can anyone tell me is this true for a user-
defined datatype (using C struct)? Thanks a lot.

Yu 





В списке pgsql-general по дате отправления
От: kamal
Дата:
Сообщение: Re: Problems with localization
От: Alvaro Herrera
Дата:
FAQ