Re: BLOB performance test FYI - Mailing list pgsql-jdbc

From Marin Dimitrov
Subject Re: BLOB performance test FYI
Date
Msg-id 001f01c1e65f$aa3bc550$9b0e32d4@sirma.bg
Whole thread Raw
In response to Re: BLOB performance test FYI  ("Joe Shevland" <jshevland@j-elite.com>)
Responses Re: BLOB performance test FYI  ("Joe Shevland" <jshevland@j-elite.com>)
Re: BLOB performance test FYI  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: "Joe Shevland"
Date:
Subject: Re: BLOB performance test FYI
Next
From: Barry Lind
Date:
Subject: Re: BLOB performance test FYI