"Mark Harris" <mharris(at)esri(dot)com> writes:
> We have recently ported our application to the postgres database. For
> the most part performance has not been an issue; however there is one
> situation that is a problem and that is the initial read of rows
> containing BYTEA values that have an average size of 2 kilobytes or
> greater. For BYTEA values postgres requires as much 3 seconds to read
> the values from disk into its buffer cache.
How large is "large"?
(No, I don't believe it takes 3 sec to fetch a single 2Kb value.)
regards, tom lane