Re: BLOB performance test FYI

----- 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. "