Re: Storing images in PostgreSQL databases (again)

Поиск
Список
Период
Сортировка
От Leonel Nunez
Тема Re: Storing images in PostgreSQL databases (again)
Дата
Msg-id 37888.201.155.188.137.1160062963.squirrel@enelserver.com
обсуждение исходный текст
Ответ на Re: Storing images in PostgreSQL databases (again)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Storing images in PostgreSQL databases (again)  ("Guy Rouillier" <guyr@masergy.com>)
Список pgsql-general
> "Merlin Moncure" <mmoncure@gmail.com> writes:
>> ... postgresql will toast all images over a cerain size which
>> is actually pretty efficient although can be a problem if your images
>> are really big.
>
> But any reasonable image format is compressed already (or at least, if
> you are using an uncompressed format while worried about disk space then
> you need some time at image processing boot camp).  TOAST isn't going to
> accomplish anything.
>
> I think the arguments for keeping stuff inside the database are
> (a) far easier to maintain transactional semantics for insert/delete,
> and (b) easier to serve the data out to clients that aren't on the same
> machine.  You aren't going to find a performance win though.
>

 (c) easy to replicate
 (d) easy to  load balancing


leonel



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

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: Generating synthetic keys on copy
Следующее
От: "Brian J. Erickson"
Дата:
Сообщение: PostgreSQL Database Transfer between machines(again)