Re: Storing images in PostgreSQL databases (again)

Поиск
Список
Период
Сортировка
От Marco Bizzarri
Тема Re: Storing images in PostgreSQL databases (again)
Дата
Msg-id 3f0d61c40610050122i47f1dfffh1154f872da024119@mail.gmail.com
обсуждение исходный текст
Ответ на Storing images in PostgreSQL databases (again)  (TIJod <tijod@yahoo.fr>)
Список pgsql-general
Hi.

I can provide some "insight" on the difference between the two interfaces.

AFAIK, the difference is in size of the file you can store, and in the
interface you have when you want to access.

The size is not important (I think), since you are far below the limit.

For the interface, the bytea gives you a "query" based interfaces,
while largeobject are able to provide a file based interface.

With Large Object, you can avoid reading the whole object with one
read, or you can even move inside the Large Object, which can be
useful if you have large files stored.

I think there are differences also in how the space is reclaimed, but
my PostgreSQL - Fu stops here.

Regards
Marco

--
Marco Bizzarri
http://notenotturne.blogspot.com/

В списке pgsql-general по дате отправления:

Предыдущее
От: Matthias.Pitzl@izb.de
Дата:
Сообщение: Re: Help required
Следующее
От: "Peter Bauer"
Дата:
Сообщение: Re: Major Performance decrease after some hours