Re: BLOB performance test FYI

Поиск
Список
Период
Сортировка
От Marin Dimitrov
Тема Re: BLOB performance test FYI
Дата
Msg-id 001f01c1e65f$aa3bc550$9b0e32d4@sirma.bg
обсуждение исходный текст
Ответ на Re: BLOB performance test FYI  ("Joe Shevland" <jshevland@j-elite.com>)
Ответы Re: BLOB performance test FYI  ("Joe Shevland" <jshevland@j-elite.com>)
Re: BLOB performance test FYI  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-jdbc
----- Original Message -----
From: "Barry Lind"

>
> This is all explained to some degree in the documentation for 7.2.  It
> is left as a choice to the user to use the datatype best suited for
> their circumstances given the pros and cons of the different alternatives.
>

the docs do not mention that storing even a 500KB of binary data is 40 times
slower with byte when compared to LO

besides, 500KB is all but the "very large value" that is mentioned in the
docs

provided that people have outlined the problems that lead to the poor byte
performance (the backend parses the input) and that these problems seem to
be unresolvable, then wouldn't it be a better mid-term solution to switch to
LO and hope for improvements related to LOs in next releases rather than
using byte at all?


    Marin

----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "




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

Предыдущее
От: "Joe Shevland"
Дата:
Сообщение: Re: BLOB performance test FYI
Следующее
От: Barry Lind
Дата:
Сообщение: Re: BLOB performance test FYI